Combo Box allows blanks

  • Thread starter Thread starter jovii
  • Start date Start date
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.
 
At the table design set that field's Required property to Yes. However you
need to fix any blanks already there first.
 
Back
Top