Thanks for the help OssieMac,

Can you show me an example of just numeric and just alpha?

Lets say the Text box Name is FirstName and for numeric CellPhone. Can I not
do it through the properties of a field from the user form?

Thanks in Advance

"OssieMac" wrote:

Hi Sam,

Need code to validate the entries. However, need a spec for each textbox
before writing the code. Spec info required.

Name of each textbox with following info.
Valid characters. (All numeric, all alpha, numeric/alpha)
If numeric/alpha is it a set number of numeric and alpha or random.
If random are all alpha together and all numeric together or mixed.
Describe set numeric/alpha as ####@@@@@ (for 4 numeric and 5 alpha.)
Alpha characters (if Uppercase,Lowercase or does not matter)

--
Regards,

OssieMac