String matches required Format in VBA

[psycoperl]

I have an inputbox that a user is entering information as part of a VBA Sub.

I want the user to enter their Activity Code(s) which are in the format of ZZZZ.000 is there a way to check if the format of the string matches the required format? Where Z is any letter A-Z and 0 is any digit.

Thanks

 

[Joe4]

Instead of having them enter data using an InputBox, why not use a Form?

If you do that, you can use an Input Mask of LLLL.000, which will do what you want.

Otherwise, you may need to write some VBA to validate the entry.

 

[HiTechCoach]

I agree with Joe4 recommendation to use a form.

I over 15+ years of doing Access development I have used the input box maybe once or twice. Since it does not allow any data validation, etc. I just find it not very user friendly.

I would use a form to display a list of the available codes. If picking a single code you could use a combo box. If selecting multiple codes I use a listbox or a sub form.