RegionsRob
Programmer
I've just read all the past threads here regarding this topic. Setting the format to > or < for each field would work for some of my fields, but not all. One person asked why anyone would want to change the CapsLock setting instead of just setting the format. Well, here is a situation:
Information fields I want in all caps. This is where I could just set the format for the field in the table. Note/comment fields I need to be in "normal" text, with mixed case as typed. The best way to do this is to set the CapsLock state on the field's Enter event on the form.
Now, I can hear some of you saying "Just leave the CapsLock off and the formatting will take care of everything for you." This is true, but aesthetically UGLY. A further complication is that I am constantly moving between open applications, and I want to make sure the CapsLock state is set correctly when I return to Access.
I need a routine that will set the CapsLock ON and another that will set it OFF.
Information fields I want in all caps. This is where I could just set the format for the field in the table. Note/comment fields I need to be in "normal" text, with mixed case as typed. The best way to do this is to set the CapsLock state on the field's Enter event on the form.
Now, I can hear some of you saying "Just leave the CapsLock off and the formatting will take care of everything for you." This is true, but aesthetically UGLY. A further complication is that I am constantly moving between open applications, and I want to make sure the CapsLock state is set correctly when I return to Access.
I need a routine that will set the CapsLock ON and another that will set it OFF.
