Changing Field Property AllowZeroLength Doesn't Change Design

[Dennis W. Bulgrien]

Given that the first field of the first table is Type = dbText, AllowZeroLength
= False, why does CurrentDb.TableDefs(0).Fields(0).AllowZeroLength = True show
in Watch that AllowZeroLength becomes True but when I open the Design and look
at the field properties it is still False?

 

[Dennis W. Bulgrien]

I had had another of the table Design windows open. I closed it, ran VBA again,
same effect. I closed Access, reopened, still showed to be False, ran it again,
it stuck; Design property shows True. I'm happy now.

"Dennis W. Bulgrien" <dbulgrien vcsd com> wrote in message
....why does CurrentDb.TableDefs(0).Fields(0).AllowZeroLength = True show
....field properties it is still False?

 

[Tim Ferguson]

why does CurrentDb.TableDefs(0).Fields(0).AllowZeroLength = True show
in Watch that AllowZeroLength becomes True

How do you know which table is indexed as TableDefs(0)? AFAIK, the order of
objects in system collections is by definition undefined, so there is no
way of knowing which table you are altering.

Try CurrentDB().Tabledefs("MyTable").Fields("MyField").etc...

B Wishes


Tim F