I am drawing a blank and need some help. I need to format a textbox after
it's been updated to the format XXX9999-999. The X's are either Letters or
Numbers and are required, the 9's are any number 0-9. I know how to write
the format, however I don't know how to format the X portion to accept either
Letters or numbers.

Textbox.Text = Left(Textbox.Text,7) & "-" & Right(Textbox.Text,3)

Data in a textbox is string data and you can't "format" string data.

If it is all numeric, then it would be coerced to a number in the format
command, but as you say, if alpha-numeric, this doesn't work.

--
Regards,
Tom Ogilvy


"Thomas L" wrote in message
...
I am drawing a blank and need some help. I need to format a textbox after
it's been updated to the format XXX9999-999. The X's are either Letters
or
Numbers and are required, the 9's are any number 0-9. I know how to write
the format, however I don't know how to format the X portion to accept
either
Letters or numbers.