Warning Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help please - is it possible to give a warning on an unbound input form if a
required field is left blank in Access 2000

Thanks for any help
 
Mike said:
Help please - is it possible to give a warning on an unbound input
form if a required field is left blank in Access 2000

Thanks for any help
Click to expand...

If IsNull(Me.ControlName) Then MsgBox("HEY!")
 
On the unload event of the form, you can write the code

If Me.[Text Box Name] = "" Or IsNull(Me.[Text Box Name] ) Then
msgbox "Null Null"
cancel = true ' Wont let the user close the form
Me.[Text Box Name].SetFocus ' return the focus to the field
End If
 
Back
Top