Combo box in table but shows as Text box in Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am fairly new to access. I created the table first. Then went to create a
form. Some of the combo boxes are showing up as text boxes in the forms.
Therefore my dropdown lists is not showing up. I have checked the properties
of those that are showing correct against those that are not and they appear
to be the same. I am obviously missing something. Any and all suggestions are
welcomed.

Thanks,
Dan
 
suggest you get rid of the combo boxes (called Lookup fields) in your
tables. they'll cause you a lot of grief in the long (and short) run. see
the link below for details

http://www.mvps.org/access/lookupfields.htm

to create a combo box control in your form, suggest you use the combo box
wizard to get an understanding of the decisions you need to make in setting
up a combo box. then look at a finished combo box control, using Help to
read up on the following properties especially: RowSourceType, RowSource,
ColumnCount, ColumnWidths, BoundColumn, LimitToList.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top