Combobox does not allow a blank entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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.
 
You could get around this using code but it is easier to insert a blank
record and I believe in easy.
 
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
 
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
 
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
 
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
 
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
 
Are you recommending going into all of the required tables and just adding a
blank record ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combobox null entry 3
Limiting Combo Box Entry Based On Another Field 2
Use of List box and 'Index or primary key cannot contain null" 2
Preventing combobox from showing no record. 2
Combo Box allows blanks 2
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Not In List question 1
duplicate form after selecting value in combobox 0

Back
Top