By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,510 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,510 IT Pros & Developers. It's quick & easy.

drop list

P: n/a
hi all !

i have a drop down list in a form.
the users of the data base are typing text in there instead of
selecting from the list.
how can i make it so they cannot type text and only select what is in
the drop down list.

thanks
brino

Mar 15 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Does it help if you set the Not In List property of the combo?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"brino" <bd*************@yahoo.com.auwrote in message
news:11**********************@n76g2000hsh.googlegr oups.com...
hi all !

i have a drop down list in a form.
the users of the data base are typing text in there instead of
selecting from the list.
how can i make it so they cannot type text and only select what is in
the drop down list.

thanks
brino
Mar 15 '07 #2

P: n/a
On Mar 15, 6:43 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
Does it help if you set the Not In List property of the combo?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"brino" <bdsolutions2...@yahoo.com.auwrote in message

news:11**********************@n76g2000hsh.googlegr oups.com...
hi all !
i have a drop down list in a form.
the users of the data base are typing text in there instead of
selecting from the list.
how can i make it so they cannot type text and only select what is in
the drop down list.
thanks
brino
i couldnt find the "not in list" property on the table design.
i tried the "limit to list" property but this did not work.
i dont know what else i could do , i may have to change it to an
option group ???
thanks
brino

Mar 15 '07 #3

P: n/a
What happened when you set Limit To List to No?

What should happen is that if the user types something that is not in the
list, Access stops them from proceeding until they make a valid choice.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"brino" <bd*************@yahoo.com.auwrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...
On Mar 15, 6:43 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
>Does it help if you set the Not In List property of the combo?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"brino" <bdsolutions2...@yahoo.com.auwrote in message

news:11**********************@n76g2000hsh.googleg roups.com...
hi all !
i have a drop down list in a form.
the users of the data base are typing text in there instead of
selecting from the list.
how can i make it so they cannot type text and only select what is in
the drop down list.
thanks
brino

i couldnt find the "not in list" property on the table design.
i tried the "limit to list" property but this did not work.
i dont know what else i could do , i may have to change it to an
option group ???
thanks
brino
Mar 15 '07 #4

P: n/a
(Set to Yes, of course)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:45**********************@per-qv1-newsreader-01.iinet.net.au...
What happened when you set Limit To List to No?

What should happen is that if the user types something that is not in the
list, Access stops them from proceeding until they make a valid choice.

"brino" <bd*************@yahoo.com.auwrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...
>On Mar 15, 6:43 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
>>Does it help if you set the Not In List property of the combo?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"brino" <bdsolutions2...@yahoo.com.auwrote in message

news:11**********************@n76g2000hsh.google groups.com...

hi all !

i have a drop down list in a form.
the users of the data base are typing text in there instead of
selecting from the list.
how can i make it so they cannot type text and only select what is in
the drop down list.

thanks
brino

i couldnt find the "not in list" property on the table design.
i tried the "limit to list" property but this did not work.
i dont know what else i could do , i may have to change it to an
option group ???
thanks
brino
Mar 15 '07 #5

P: n/a
On Mar 15, 8:27 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
(Set to Yes, of course)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Allen Browne" <AllenBro...@SeeSig.Invalidwrote in message

news:45**********************@per-qv1-newsreader-01.iinet.net.au...
What happened when you set Limit To List to No?
What should happen is that if the user types something that is not in the
list, Access stops them from proceeding until they make a valid choice.
"brino" <bdsolutions2...@yahoo.com.auwrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...
On Mar 15, 6:43 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
Does it help if you set the Not In List property of the combo?
>--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>"brino" <bdsolutions2...@yahoo.com.auwrote in message
>>news:11**********************@n76g2000hsh.google groups.com...
hi all !
i have a drop down list in a form.
the users of the data base are typing text in there instead of
selecting from the list.
how can i make it so they cannot type text and only select what is in
the drop down list.
thanks
brino
i couldnt find the "not in list" property on the table design.
i tried the "limit to list" property but this did not work.
i dont know what else i could do , i may have to change it to an
option group ???
thanks
brino- Hide quoted text -

- Show quoted text -
thanks Allen this worked ok !

Mar 15 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.