Set the minimum amount of characters in a text box

[ChrisHaynes]

Hi, How can I check that a field in my form contains a minimum of say, 5 characters when I click a command button?

I am going to use it with an if statement for example:

if Me!Password (is less than 5 characters long) then
msbox "Password needs to contain a minimum of 5 characters"

Thanks,
Chris

 

[Spenney]

Hint: Take a look at the 'Len' function...

 

[ChrisHaynes]

Thanks Spenney. I have it sorted now

 If Len(Me!Username) < 7 Then
       MsgBox "Username needs to contain a minimum of 7 characters", vbOKOnly & vbCritical, "Invalid Username"

Chris.