[AccessD] Modifying Table Field Properties

John Skolits askolits at ot.com
Wed Oct 4 13:18:00 CDT 2006


I want to modify the AllowZeroLength field property of a table thru VB Code
I believe I had actually done this many years ago, but can't find the code.

The end result will allow me to enumerate through all the fields and set
that property to True.


I can retrieve the value using :

Currentdb().TableDefs("Table1").Fields("AllowZeroLength).Property(16).value

But can't set the value. 
If I could set it, it would be easy to write a 'For Each' routine to go
through all my tables and change this.

John








More information about the AccessD mailing list