Change to previous message

  • Thread starter Thread starter netadmin
  • Start date Start date
N

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.
 
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.
Click to expand...

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
 
Back
Top