How to hightlight fields that are null in a form (1 Viewer)

[Nick.NZ]

Hey guys,

Another question. When I click the save button on a form, before it saves the data, is there a way to check null fields, and highlight them?

Thanks Nick

 

[arnelgp]

you need to add code to the Form's BeforeUpdate to Cancel if there are
some blank fields.
it is best to use Tag property of the control, so only those with tags are
actually checked.

adding a button (and code on the button) on your form will not prevent it from saving the record.
you need to check it in the Form's beforeUpdate event.

if you need for those buttons to work as intented, you need to add Transaction to your form.