Reset Value to Null 1

[Ajwebb]

Hi All,

I have a text box and on the After Update Event i have code which brings me up a message box if the text is entered in the wrong format.

However after my message box has been displayed i would like the text in my text box to be deleted.

How can i do this?

Thanks in Advance All

Anthony

 

[coco86]

Try adding the line

Me.txtboxname = Null

after the msgbox line

-Coco

 

[Ajwebb]

Cheers Coco

Ant