Drop Down in Form View

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!
 
D

Douglas J. Steele

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.
 
A

Athaydes

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.
 
K

Kristen

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!!
 

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

Similar Threads

Combo List Drop Down Arrow 2
Drop Downs 1
Drop down boxes 1
Drop-down boxes 2
Drop Down List 2
F4 will not drop down list for combobox in datasheet view 3
Form and lost drop down list 1
Variable drop-down list? 3

Top