Combo Box

[Mary Fetsch]

In Access 2000, one of my fields is a combo box, so the
user can either enter a value or choose a value from a
list. Is there a way in Visual Basic to know whether the
user entered a value or chose from the list?

 

[Mark]

Hi,

By setting the Limit to List property to Yes. Users are forced to select
from a list.

For adding new items to the list at the same time (by the users) see the
NotInList event link below:

http://www.mvps.org/access/forms/frm0015.htm

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/

 

[Mary Fetsch]

Thanks for your response, Mark. I've already done what you suggest. Let's
say my combo box is a list of states. I'm looking for a way to know if the
user entered the characters "Florida" or if the user chose "Florida" from
the list.

 

[Mark]

I can't think of a way of doing that.

Thanks for your response, Mark. I've already done what you suggest. Let's
say my combo box is a list of states. I'm looking for a way to know if the
user entered the characters "Florida" or if the user chose "Florida" from
the list.

 

[Bob H.]

You could always add a period at the end of the listed
objects or a hyphen at the beginning. Most people would
not think to add such charachters after typing in their
entry. Kind of like putting a hair in your door to see if
anyone entered or exited. Just a thought..Good luck, Bob

 

[Mary Fetsch]

Great idea! Thanks, Bob
!

You could always add a period at the end of the listed
objects or a hyphen at the beginning. Most people would
not think to add such charachters after typing in their
entry. Kind of like putting a hair in your door to see if
anyone entered or exited. Just a thought..Good luck, Bob