You can set the field to run an Auto-enter Calculation on the field and when the user clicks out of the field it will runa calculation that will change the contents to Upper case.
Go into the database field definitions and highlight the field in question.
Now under the 'Auto-enter' tab click on the check box for 'Calculated value' a Specify Calculation dialog will appear and here is where you enter the calc to reformat the text to upper. Input the following
Upper ( FieldName )
Deselect the option 'Do not replace existing value of field (if any)' so the calc will run whenever the field is modified.
And click 'Ok'
Let me know how you get on.
Perfect! thanks so much!
No worries Adam, glad I could help.
I was searching for this solution for an half an hour, you helped me a lot.
Instead the Upper ( FieldName ) an easier method may be Upper ( Self )