Hi to all. I like to change the data type, format and
display control for a field in a table via VB. Such as
field1, data type = "Yes/No". Under the general tab,
Format = "Yes/No" and under Lookup tab, Display control
= "Check box". Is this possible? An example would be a
big help.

Thanks in advance.

"Harry" <(E-Mail Removed)> wrote in
news:13c7a01c38491$221fce60$(E-Mail Removed):

> I like to change the data type, format and
> display control for a field in a table via VB.

Ummm: don't display fields in tables. That is what forms are for.

Changing a data type is a Major Design adjustment -- it's not the sort of
thing you would do more than once, and so it's easier just to do it once
using the design window than work out how to do it programmatically.

Similarly, the format property only makes a difference when you are
designing forms, so if you have access to the UI in order to create and
edit the form, then you also have access to the tabledef design to change
it there too.

And I just don't know of any legitimate use of the "display control"
property, except to attempt to lead new users into the mistake of thinking
that table datasheets are reasonable ways to edit data in.

B Wishes


Tim F