Required Field in a Form

[Guest]

I have a required field called LastName in a form. If I make this a required
field in the table the form is based on and it is left blank when inputing a
new record, Access comes up with a cryptic message box telling the user the
LastName field cannot be blank and preventing the record from be inserted in
the table.

My question is, how can I circumvent the Access message box with one of my
own design telling the user to complete the LastName field?

Kevin D.

 

[Rick Brandt]

I have a required field called LastName in a form. If I make this a
required field in the table the form is based on and it is left blank
when inputing a new record, Access comes up with a cryptic message
box telling the user the LastName field cannot be blank and
preventing the record from be inserted in the table.

My question is, how can I circumvent the Access message box with one
of my own design telling the user to complete the LastName field?

Kevin D.

Check the field in the BeforeUpdate event of the form and set Cancel = True when
it is Null. In the same code you can display a MsgBox() with whatever text you
like.

 

[Guest]

Thanks Rick for your prompt response.

Kevin

Check the field in the BeforeUpdate event of the form and set Cancel = True when
it is Null. In the same code you can display a MsgBox() with whatever text you
like.