Hide combo box drop down menu in Form

[Guest]

I've created tables with combo box drop down menus. When I turn a query into
a form, these drop down fields are listed on the form. I want only the data
to display, not the pull down options. Is there a way to turn them off in
the form, not the table. Thank you.

 

[tina]

you have to open the form in design view, and change each combo box control
into a textbox control. in Access 2003, you can do that by clicking on a
control to select it, then clicking Format | Change | Textbox from the menu
bar. i don't recall if that menu option is available in A2000; if not, you
need to add unbound textbox controls to the form to replace the combo box
controls, and bind each textbox control to an appropriate field in the
form's underlying query.
recommend you get rid of the Lookup fields in your tables, though. for more
information, see http://www.mvps.org/access/lookupfields.htm

hth