By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,949 Members | 2,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,949 IT Pros & Developers. It's quick & easy.

Setting table property via code

P: n/a
Hi

Is it possible to set Allow Zero Length = Yes property for all relevant
fields automatically via code?

Thanks

Regards

Jan 17 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
John:
Yes, here's an example of a function to do that:

Public Function SetToZero()
Dim MyTable As TableDef
Dim db As Database
Dim MyField As Field
Set db = CurrentDb
Set MyTable = db.TableDefs("YourTableName")
Set MyField = MyTable!YourFieldName
MyField.AllowZeroLength = True
End Function

HTH,
Jana

John wrote:
Hi

Is it possible to set Allow Zero Length = Yes property for all relevant
fields automatically via code?

Thanks

Regards
Jan 17 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.