display message if field left empty (1 Viewer)

[gpurger]

Hi,
I am trying to notify users to fill a specific field in if they forget it and can not work out which event to use.
Can you please help

Cheers

g

 

[jrjr]

I typically use a submit button and in the onclick event will be code like this:

If IsNull(YourControlName) Then
MsgBox "You have to choose something in the YourControlName field!", , "Incomplete Form!"
YourControlName.SetFocus
End If

 

[ghudson]

Use the forms BeforeUpdate event.

 

[selenau837]

I typically use a submit button and in the onclick event will be code like this:

If IsNull(YourControlName) Then
MsgBox "You have to choose something in the YourControlName field!", , "Incomplete Form!"
YourControlName.SetFocus
End If

I have the same thing on my forms. However, another way I have tried to help the user, is to make the background of the required field a pale yellow color. That is also a visual way for them to know it is required outside of the validation code listed above

 

[gpurger]

Thanks for that

G