How to set the "caps Lock Key" when entering a text field
I would like to use conditional formatting to set the "caps lock key" when entering text into a text field. And then use conditional formatting to reset the "caps lock key" when entering another field. Setting a field to Upper Case does not provide the same result because "MacGRATH" turns into 'MACGRATH" which is not what I want. I have not found anyway to send the appropriate code to the keyboard. Can this be done?