Combo Box allows blanks

[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.

 

[Jerry Whittle]

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

 

[jovii]

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

Thanks Jerry, that solves my problem