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