Link to home
Start Free TrialLog in
Avatar of Sanjay
SanjayFlag for United States of America

asked on

vba code to change text fields to upper case

I have a table called "Labor" with several fields, some of which are text.  I need expert help in developing a vba sub that upon execution, converts all these text based fields to upper case.  The exception is with one field is called "Misc" (also text) which should not be converted to upper case.  Please help.  Thanks.
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Of course, you could also use code on your forms to enfore all upper case on the appropriate controls on the BeforeUpdate event...
Avatar of Sanjay