[AccessD] Modifying Table Field Properties - Resolved!

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


Just figured it out. I was trying to modify a field that did not have that
Property. It was a numeric field. Although it still returned a value for
that property in code. That's what threw me off. (Isn't that odd?)

----

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