Performing an action before opening form.

[Paul S]

I want to have the CapsLock key turn on before a certain form is opened. Does
anybody have some VB for this? Thanks.

 

[PieterLinden via AccessMonster.com]

I want to have the CapsLock key turn on before a certain form is opened. Does
anybody have some VB for this? Thanks.

One option is to turn it on when the form opens... or just apply the shift to
uppercase when the user exits a field... or just *show* everything in
uppercase on the form... use a mask for it. It will not affect the data in
the tables, though.

 

[Douglas J. Steele]

Are you sure? Personally, I'd refuse to use an application that insisted on
changing my settings...

If you are, check out http://www.mvps.org/access/api/api0046.htm at "The
Access Web". You'd want the ToggleCapsLock subroutine there (but note that
you'll need to copy a lot of the other declaration stuff to make that work)

 

[Jeff Boyce]

Paul

You've described "how" you want to solve an issue (i.e., force all CAPS),
but not "why" or "what".

What will having all CAPS do for you/your users?

Regards

Jeff Boyce
Microsoft Office/Access MVP