is it possible to create a drop-down menu in a text field?

M

MARTIN95

i have a text field for Client Type.

i would like to limit the user's entry by creating a drop-down menu with the
appropriate and required selections.

if this is possible, how?

thanks
 
F

fredg

i have a text field for Client Type.

i would like to limit the user's entry by creating a drop-down menu with the
appropriate and required selections.

if this is possible, how?

thanks
Click to expand...

What are the appropriate selections?

I'll guess it's something like "East", "North" ,"West", or "South".

Add a Combo box to the form.
Set it's RowSourceType to Value List.
Set it's Rowsource to:
"East", "North","West","South"

Set it's bound column to 1.
Column widths to 1".
Set the combo box control source to the text field.

Select an item in the list and it will be saved to the text field.
 
J

John Vinson

i have a text field for Client Type.

i would like to limit the user's entry by creating a drop-down menu with the
appropriate and required selections.

if this is possible, how?
Click to expand...

Sure. A combo box wouldn't be much use if you couldn't!

Create a Table with the "appropriate and required selections" for
client type. Use it - or, better, a query sorting it alphabetically -
as the row source for the combo box (i.e. when the wizard asks where
the data will come from select Table, and then choose this table).

John W. Vinson[MVP]
 
Z

Zack L

Hi, thanks for your answer below, I was wondering how to do this in a table?
ie to make a drop down menu with options appear for a field in a table.
Thanks for any help you can give.
 
F

fredg

Hi, thanks for your answer below, I was wondering how to do this in a table?
ie to make a drop down menu with options appear for a field in a table.
Thanks for any help you can give.
Click to expand...

Tables are used to STORE data, not for direct data entry or data
manipulation.
Using a combo box (in a table it would be called a 'lookup' field) in
a table field will lead to unwanted side effects, because what you
will see is not what will be stored.
It's always best to use a form for data entry.
On a form you can use a combo box.
 
Z

Zack L

Thanks but I'm wanting to use the table to enter data directly. Actually I
created the drop down before and can't remember how to do it, though I've
been trying like crazy to retrace my steps. Do you know how to do it?
 
F

fredg

Thanks but I'm wanting to use the table to enter data directly. Actually I
created the drop down before and can't remember how to do it, though I've
been trying like crazy to retrace my steps. Do you know how to do it?
Click to expand...

Add a new field to the table.
Click on the LookUp tab in the lower panel.
Select Combo Box from the Drop-down.
Set the combo properties as needed,

Good luck.
 
R

ROHINKUMAR

Dear,

Replies to this question, was very much helpful to me, as I had successfully
created a dropdown list.

Thanks a lot

Rohinkumar
 
Top