Help with Access Password field

[hedonistclub]

hi everyone,

what do i write in the field's input mask to require at least the input of 1 number into the field?



thanks

[hedonistclub]

it does not necessarily have to be the input mask.

i am designing the password field and i want users to have at least 1 number in it.

[hedonistclub]

can someone help me out please

[qa12dx]

what you want is validation rule. tables have ValidationRule property. i have never used it, may be better than what i list below.

simple way i do it is use the afterupdate event.
condition; len([text1])<1 - msgbox - "needs to be more than......."
condition; len([text1])<1 - stopallmacros

input mask is to control how the object is displayed. for eg, if someone inputs their phone number as 51512345678, it can be used to display as 515-1234-5678 or mask password text, etc.