Upper case vs Lower case

[racdata]

On a form I have a field where I enter a registration number. I force Access to change the case to Upper case in the table using the >.

My question is now:
Is it possible to force Upper case in the Input box when I do a query or a Report. Because every time when a input box appear I first have to make sure that I enter the registration number in uppercase.

Thanx

 

[Pat Hartman]

That doesn't force Access to save the data as upper case. It is only a display format. Formats do not affect how data is saved. You need to convert the data yourself with the UCase() function before it is saved.

You have no way of adding your own code to an input box. If you want any control over the input, you'll need to make a form and enter the parameter there prior to running the report.

FYI, if your data is stored in Jet tables and is likely to stay there, you don't need to worry about case since Jet is not case sensitive.