Combo Box allows blanks

J

jovii

Hi all,

I'm having a problem with a combo box. The combo box shows broker
id's and broker name. The bound field is broker id, the limit to list
property is set to Yes and the Default Value is set to zero. The
broker id is defined in the details table as a number (integer).

If a user enters the wrong broker id a message pops up: The text you
entered isn't an item in the list, but if a blank is entered (hitting
the space key by accident) no message pops up and the record will be
saved with a blank broker id.

Is there another property that needs to be set in combo box or in
the table that will not allow a blank to be entered?

I am using Access 2007

Joe V.
 
J

Jerry Whittle

At the table design set that field's Required property to Yes. However you
need to fix any blanks already there first.
 

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

Top