Change field Allow Zero Length[RESOLVED]

**sacramento** · Sep 2nd, 2006, 02:22 PM

Hi to all:

I would like to change the field allowzerolenght,set to false, to true in my DB access.

Any suggestions to do this?

Thanks

**jcis** · Sep 2nd, 2006, 02:43 PM

In access, go to your table design and change allowzerolenght to True.

**sacramento** · Sep 2nd, 2006, 03:09 PM

no no...through Code!!

**sacramento** · Sep 2nd, 2006, 03:50 PM

this is the way:

VB Code:

Set top = db.TableDefs(anos)
Set fld = top.Fields("citesPai")
fld.Properties("AllowZeroLength") = True

Thanks

Thread: Change field Allow Zero Length[RESOLVED]