Validation Rule for minimum/maximum range (1 Viewer)

[Smokeeater]

I have a password field in a table, where I want to establish a validation rule for the minimum (6) and maximum (10) number of characters that it must be. Also, the field should be only alphanumeric. Is this possible?

 

[PaulJR]

You can certainly set the maximum field in the table design.

If you require a minimum and maximum, I think you will have to add some code to check the string length falls within these limits when it is entered. This would be fairly straightforward to do if the password is entered in a form.

 

[Smokeeater]

The Access database is the back-end of a web page, so even though the user is adding their password into a form, its a web form. So I will need to do some research on setting the criteria in the web form itself.

 

[PaulJR]

Had another look at the table properties, and you could add a validation rule something along the lines of:

Like "??????" Or Like "???????"

this would allow 6 or 7 digits. This can be expanded to cover between 6 and 10.

 

[Smokeeater]

Very good. I will give that a try.