Textbox validation

[aman]

Hi guys

I want to apply validation on textbox so that user can enter only 6 characters.The first character should be alphabet and other 5 should be numbers only.

Can anyone please give me the vba code for this.

Regards
Aman

 

[DCrake]

Nobody is likely to give you the code for it as your question is not complete. however if bothered to look up Input Masks in Access Help or used the Build button on the properties tab against Input Mask you may get some guidance there.

David

 

[sakthivels]

Hi,

Why dont use the input mask feature of access.

For your case the input mask will be L99999

for more information on input mask please refer to the following url

http://www.uic.edu/depts/accc/seminars/access2000-intermed/tables-input-mask.html

Regards,
Sakthivel

 

[aman]

Thanks a lot for your help.Its working absolutely fine.

Cheers

 

[sakthivels]

Glad to hear I was able to help you.

This is the way we learn from each other.