Data Validation for letters and numbers

[bassplayer79]

I'm getting the hang of Access and VBA. My app is just about complete now, and functioning quit well, really looking to test this thing out. This is also my first Access Database, so its kinda like my baby. Anyways, I'd like to add some data input validation. Right now if someone enter incorrect characters, it will return invalid Null. Id like to customize the error before it returns an error about a null value. So the part numbers will be PW001 - PW126. I know how to validate PW using IntStr, I'm just stuck on validating 001-126.

[Bob Fitz]

Perhaps you could get the numeric part using Right() function and make it numeric by using Int() function. Then check for >0 and <126

[bassplayer79]

Perhaps you could get the numeric part using Right() function and make it numeric by using Int() function. Then check for >0 and <126

Its worth a shot! Though I'm not sure how it will handle 001. I cant take that out, that is part of the actual part number.

[bassplayer79]

How would format that?

[Bob Fitz]

Perhaps something like:
Int(Right([YourField],3))

[June7]

Int() will drop leading zeros. So if they accidentally enter PW00001, this will not be caught. Perhaps you need to test the length of the number part as well as it is <= 126.

What is purpose of the data entry? Are you creating a table of parts? Or is a part being input into say an order for parts? Why not use a combobox for users to choose parts from?