VBA code a text box for dynamic length

  • Thread starter Thread starter pfm721
  • Start date Start date
P

pfm721

I have a text box tbConsultNumber. My Company recently decided it wanted to
accept authorization numbers in that spot as well. Consult numbers are 7
characters and Authorization numbers are 9 characters with the following
format 0000000-0. What I want to do is check the data in the text box to make
sure that it matches one of the two requirements and if it doesn't display a
msg box to let the user know to check the number and enter one in the valid
format.

Thanks in advance for any help.
 
pfm721 said:
I have a text box tbConsultNumber. My Company recently decided it wanted to
accept authorization numbers in that spot as well. Consult numbers are 7
characters and Authorization numbers are 9 characters with the following
format 0000000-0. What I want to do is check the data in the text box to
make
sure that it matches one of the two requirements and if it doesn't display
a
msg box to let the user know to check the number and enter one in the
valid
format.

Thanks in advance for any help.
Click to expand...

IF LEN(textbox) <> 7 AND LEN(textbox) <> 9 THEN
MSGBOX.............
END IF
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text box code 3
text box length 3
inputting a date into a text box 1
Extending Input Mask 4
text box field length 2
Dynamically update userform label based on textbox 5
Variable Length For Box On Report 1
Text box for numbers only. 1

Back
Top