Can form field box be automatically changed when table field data type changes?

[Derek Jones]

I have a form that represents a table containing various
text fields. When I use the lookup wizard to establish a
drop-down box for a field in the original table, the form
still displays only a text box for that field instead of a
combo box. Is there a setting that can be adjusted so
that the field in the form updates from a text box to a
combo box automatically, or do I always have to delete the
text box that's there and create a new combo box based on
the updated field?

Derek Jones
Software Support Specialist
Shenandoah University
Winchester, VA

 

[Gary Miller]

Derek,

If your forms already had textboxes bound to the table field
before you changed the table field to be a lookup field, no,
the forms will not automatically change the control type.
You will have to do that manually or write a routine to do
it programatically.

Most seasoned veterans will discourage doing this at the
table level and will suggest that the lookup wizard be used
at the form level instead as you have more control there on
how and what you want to display.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[admin]

You can Right click on the Text box and goto Change To - and change it to a
Combo box automatically.