Can I get all caps in Access

[melaniews]

Can someone point me to a quick way to convert all records in a field to all caps. I don't mean just displaying it in caps, I can do that. I need to have the data stored in all caps, though it may be entered in any imaginable way.

Thanks,
Melanie

 

[sha76]

Does it work just using > as the field format in the table?

 

[melaniews]

No, that just changes how it displays. The data is still stored in the table exactly as it is entered.

I appreciate your reply. I've found the answer. FYI it is
using UCase in the afterupdate event. It works very well. As soon as the user tabs out of the field, the text changes to upper case.

Thanks again,
Melanie