Restrict textbox for dropdown

[colleen1980]

There is a textbox and a drop down. Once user enters any value in the
textbox he has to select the option from drop down otherwise the cursor
will not allow to move anywhere else accept the drop down and the
textbox unless it delete the value from the textbox how to i do that
needs help

[Rick Brandt]

co*********@gmail.com wrote:

There is a textbox and a drop down. Once user enters any value in the
textbox he has to select the option from drop down otherwise the
cursor will not allow to move anywhere else accept the drop down and
the textbox unless it delete the value from the textbox how to i do
that needs help

Set LimitToList property on the ComboBox to Yes.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Ima Loozer]

In article <11**********************@e3g2000cwe.googlegroups. com>,
co*********@gmail.com says...

>
There is a textbox and a drop down. Once user enters any value in the
textbox he has to select the option from drop down otherwise the cursor
will not allow to move anywhere else accept the drop down and the
textbox unless it delete the value from the textbox how to i do that
needs help

First its called a COMBO BOX not a drop down.

Second the word you want is EXCEPT not ACCEPT.

Your question is not very clear at all. Are you describing an actual
text box and a combo box (two objects) or when you say you have a text
box and a drop down are you merely talking about a combo box only? Also
are you describing what is happening now or what you want to happen?
Lets go with the assumption that you are talking about ONLY a combo box
and that you are trying to ensure that users only enter values that are
in the list of the combo box.

To do this simply set the LimitToList property on the ComboBox to Yes!

If what you needed was something different, please try describing what
it is that is the current state of your issue and the desired state.