Testing Access form Textbox in VBA, not Null and String must be 10 or 11 Characters long

[djspod]

Hi,

I'm fairly new to VBA.

I want to check that a user is entering the correct code into the form Textbox as they press a command button which decodes the product ticket code.

The code string is always 10 or sometimes 11 characters long.

Last 1 or 2 characters of the string are always digits and the 5 character of the string is always a W (IE: 4NXOWDHBC14)

My decode VBA command button works fine.

I now want to add in error handling for the following scenarios:

• The user enters nothing in the textbox and presses the button
• The users enters less than 10 characters
• The user enters more than 11 characters.

What's the best way of attacking this in a VBA process/programming way?


I imagine with what I have already learnt in VBA, the Len function, IF and elseIf function and Msgbox's


I can't seem to get the right combination in the right order, can anyone help or point me in the right direction please.

Thanks

[pbaldy]

Numerous ways to attack this. You could test the length is 10 or 11 and only proceed if so, else throw up a message box. If you want to specifically test for them not entering anything:

If Len(Me.TextboxName & vbNullString = 0 Then

tests for both Null and a zero length string.

[davegri]

Select case len(txtbox & vbnullstring)
    Case 0
        msgbox "Can't be blank!"
    case is > 11
        msgbox "too long"
    case is < 10
        msgbox "too short"
    case else
        msgbox "looks good!"
end select

[djspod]

Both answers were brilliant and solved my problem!

Thanks to both of you for taking the time to answer.

I now have some more VBA knowledge



Cheers Darren