Combobox does not allow a blank entry

R

rmcompute

I created a combo box which is set to Yes for the Limit to List property.
The user should enter a blank or an item on the list. When they enter an
item on the list and then blank it out, it comes back. Is there a way to
allow only the item on the list or a null or do I have to insert a blank
record in the table that the list uses ?
 
A

Al Camp

rmcompute,
Something is amiss here. I have a form with 3 combos, all set to LimitToList = Yes.
They all accept "empty" (fully deleted) entries, or "null" entries without a problem.
In fact, even a "space" without any other text will not cause the NotInList error to
post.
Access rejects the space withour text automatically, and considers it an empty entry.

You wrote...
When they enter an item on the list and then blank it out, it comes back.
Click to expand...

I don't understand that statement. Please explain further as to what you mean by "it
comes back". What is IT, the value selected from the combo that you entered before
"clearing the field, or... the Not In List error message?

Try adding a button to the form called Clear. Use the Click event to...
cboYourCombo = Null
and have your users "clear" the field that way. See if that makes a diffrenece.
 
J

jahoobob via AccessMonster.com

You could get around this using code but it is easier to insert a blank
record and I believe in easy.
 
R

rmcompute

Al,

The drop down lists look like this:

Period: May-2006___
Branch: Atlanta______
PCSR: John Smith_____

When I select the branch, there is code on the click event to select the
proper list of possible PCSRs. When I selected Atlanta, I get a list of
possible PCSRs and select John Smith which is highlighted. I then hit the
delete key and click on Branch or Period and John Smith returns. If I click
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
R

rmcompute

Are you recommending going into all of the required tables and just adding a
blank record ?
 
Top