Check that field is not blank

[jsnunez]

Hi all

In a adp form bounded to a table.

What is the best way to check if a field has a value ?

I have a field where the user enters dates. The field is required. The is not a default value, such as today's date.

thanks
Jose

 

[lupins46]

Use the Form_beforeupdate event procedure and test the field. If it is empty then cancel the update by setting Cancel = True and use a msgbox to advise the user.