Forcing uppercase letters in a control

[Talismanic]

Is it possible to force upper case letters in a text box or can I change a lower case to upper with code? The data will be alpha numeric similar to this K345.

I have to export this data to a Unix program that does not allow lower case letters so I need to prevent the above from being entered as k345.

 

[Jimmy Turnip]

Try using an input mask. E.g. If every value in your field looks like "K345" then use then input mask "L000". If you define it in the table, then it will be automatically copied into any forms that you subsequently create.

 

[Talismanic]

Thanks, but that will now work because there are different employee numbers for different areas. Some have a letter prefix but most do not. I have to keep the ones that do (about 1/3) from getting entered incorrectly.

 

[Robert Dunstan]

Hi,

You can use this code to convert to uppercase

txtYourControlName = strConv(txtYourControlName, vbUpperCase)

This will work fine for converting text boxes that contain alpha numeric characters.

HTH
Rob

 

[Talismanic]

THANK YOU VERY MUCH!!! It worked great.