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