Change to previous message

[netadmin]

I stated in previous email about clearing a field, it is
not that I need to know about checking the fields in form
as per previous message.

 

[John Vinson]

I stated in previous email about clearing a field, it is
not that I need to know about checking the fields in form
as per previous message.

I'm not sure what you're saying here...

To check the fields use the Form's BeforeUpdate event. To allow for
the possibility that the textbox might be either NULL or an empty
string, the safe test is:

If Me!txtX & "" = "" Then
MsgBox "This textbox should be filled in"
Cancel = True

To clear textboxes selectively just set them to NULL; to clear the
entire form use

Me.Undo