To validate that the Combo box save's only 6 digits

[Kannan07]

Hi, I wanted the combo box in my form to accept only 6 digits not more or less than 6. Could anyone help with the code that I need to write in VB

[hariharanmca]

Hi, I wanted the combo box in my form to accept only 6 digits not more or less than 6. Could anyone help with the code that I need to write in VB

if len(trim(cmbName.Text))<>6 then
         msgbox "Enter 6 digit",vbInformation
end if

[Killer42]

if len(trim(cmbName.Text))<>6 then
         msgbox "Enter 6 digit",vbInformation
end if

Thanks for that.

Just a note - you'll want to be careful where you do this kind of check. For example, if you do it in the LostFocus event, your user may find they can't quit the program because it won't let them go to the "Cancel/Exit" button