Case Entry

[TashaSpicer]

Is there a way in Access to control the method of entry? I have been told there is a way to set it to either all upper, all lower, or proper capitalization, but I am unsure how to do this. Any ideas? Thanks!!

 

[wazz]

have a look at input mask syntax.
there are also functions you can use in vba, like UCase().

 

[gemma-the-husky]

its quite awkward though - it does mean looking carefully at virtually every interface element in your database - why not leave it to the users to get it right.

 

[boblarson]

And don't worry about how it is stored, just use a query with the formatting the way you want it when you want data out.