Required field code 1

[RGarcia87]

Need code for an Access 2007 form. When a user exits the form and a certain field is not filled I want it to say "This field is required!". I would really appreciate it.

 

[genomon]

Put a message box in the form's unload event inside an IF statement. If the field is not filled, set cancel = true.

Cogito eggo sum – I think, therefore I am a waffle.

 

[redwoodly]

Or can do it in BEFORE UPDATE with a message box:

If IsNull(Me!txtField) Then
MsgBox "FIELDNAME is required", vbOKOnly, "Rqd Field Missing"
Cancel = True
Me!txtField.SetFocus
End If

 

[boblarson]

I concur with redwoodly that you do this in the BEFORE UPDATE event.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[RGarcia87]

Thanks redwoodly, it worked!