I would like the enduser to be able to highlight text within a memo field and use a shortcut key to make it all uppercase. It's essentially the same as running the VBA code:
which I have in the 'update' event in another area of the database. The deal is I don't want the *entire* field to be uppercase, just the selected text. Going to the format menu is not an option.
Is there a way to do this?
Onwards,
Q-
Code:
Forms!formname!fieldname.Value = StrConv(Forms!formname!fieldname.Value, vbUpperCase)
which I have in the 'update' event in another area of the database. The deal is I don't want the *entire* field to be uppercase, just the selected text. Going to the format menu is not an option.
Is there a way to do this?
Onwards,
Q-