>To All:
>Please recommend ways of checking a TextBox to see if it is empty or also that it contains only Alpha characters. The code should then post a MessageBox telling the operator that the field cannot be blank or some character is invalid. Then the cursor should return to the same field to allow correction of the problem. I tried using the Valid event but it pops a nasty little wait window that I would rather not see. I will use this code to check each Textbox on the form.


Eric;

Set the Format property of the text box to A (Allows alphabetic characters only (no spaces or punctuation marks).

In the valid:

If len(this.value) = 0
Msgbox “Your message”
Return 0
endif