Drop Down in Form View

  • Thread starter Thread starter Kristen
  • Start date Start date
K

Kristen

I have a question that may seem simple to many, but its driving me crazy! I
am creating a database for a property management company composed of all our
vacant properties. In design view, I have the fields I want a drop down in as
list box with the different options in the row source.When I switch to
datasheet view the fields work fine, the drop down boxes are there as drop
down boxes with the arrow to click to make them drop down. But when I go to
Form view, next to the field is a box with an up and down arrow and all the
options are displayed, as a list rather than a drop down where you select
one. How do I change this to be displayed as a drop down rather than all the
options displaying in a list? I hope this question makes sense but my lack of
computer knowledge is limiting me from explaining it better!! thanks!
 
Any reason why you're not using a combo box rather than a list box? The
combo box is what Access calls the VB drop down box.
 
You might actually have a list box in the form instead of a combo box, which
by what you describe, is what you want.
To change that is very simple. Open the form in design view, right-click the
list box, select option "change to", then select "combo box" (this is the
procedure in Access 2003, but in Access 07 it should be very similar to do).
If that doesn't work, delete your listbox from the form, then create a combo
box, and set the property "Row source" (in the 'data' tab of the properties
window) to the table or query where the data you want to display comes from.
 
THANKS THANKS!! I appreciate your help. I knew it would be simple but for
some reason I was having trouble!!! I know where to come from now on!!
 
Back
Top