Thanks for your replys everyone, though I haven't quite got it working
yet.

I should have been more specific, but Tom, you assumed correctly that
this is a textbox as part of a form. I have successfully protected the
field to only allow numerics, and have restricted the maxlength of the
field. I have yet to restrict to the values I stated earlier.

I changed 'TextBox1' to my assigned field name, 'txtBAN', however when
I run the form the debugger does not like the line:

txtBAN.Activate

Any additional help would be most appreciated.

Dillonstar


--
Dillonstar
------------------------------------------------------------------------
Dillonstar's Profile: http://www.excelforum.com/member.php...fo&userid=1814
View this thread: http://www.excelforum.com/showthread...hreadid=159534