exact number of characters in textbox
in the appropriate event for the textbox, use the len function
if len(me.Textbox1.Text) < 11 then
There are two kinds of text boxes and textboxes can be located on
worksheets, userforms, dialogsheets, and a more specific answer would
require more specific knowledge although you will probably get some guesses.
--
Regards,
Tom Ogilvy
"JNW" wrote in message
...
The program I am developing requires employees to enter information about
customer numbers. These customer numbers are always 11 digits long. I
know
how to limit the textbox to 11 characters but how do I check to see if all
11
characters were entered?
|