Change Text To Uppercase In A Macro

  • Thread starter Thread starter Jonathan Carroll via AccessMonster.com
  • Start date Start date
J

Jonathan Carroll via AccessMonster.com

Hi,

How do u change text into uppercase in a macro in access? I can't not
remember how to do this it was some time ago.

Thanks

Jonathan Carroll
 
Jonathan,

If you are talking about a field control, you can use a macro with the
SetValue action, with these arguments...
Item: [NameOfTextbox]
Expression: StrConv([NameOfTextbox],1)

If you are talking about the data in a field in a table, you can use an
Update Query to update YourField to StrConv([YourField],1) and if you
need to automate this with a macro you would then use the OpenQuery
action to run the update.
 
You "can't not"...? :

In any case, I'm not certain how you'd do it in a macro but a bette
approach might be to use an input mask to automatically make all tex
entered in a particular field uppercase
 
Back
Top