Change Text To Uppercase In A Macro

[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

 

[Steve Schapel]

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.

 

[Pringle9984]

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