uppercase?

[slimjen]

Hello All, Using 2003; I have a database that imports data from a spreadsheet. When I look at the data in the table; its in all caps. but when I view it in a form for editing or report, some of the data is in lowercase. I need it to be upper case like in the table. I tried the Keypress code but it only changes new data not existing. Why does it change case in the forms and on the report and how can I force it to uppercase.


thanks.

[June7]

The table must have format setting for display in all caps. Format setting does not actually change the data. Review this article about format property http://office.microsoft.com/en-us/ac...010334645.aspx

Check the Format property of field in table. Does it show a > character? This forces all text to be uppercase. You can use this same character in Format property of controls on form.

[slimjen]

Got it. Thanks so much!