Quote:
>Why does the use of SendKeys in VBA toggles Num Lock and Caps Lock?
Because of a deep-seated and apparently unfixable bug in Windows.
Most serious developers try to avoid ever using SendKeys. There are
alternatives for almost everything you can do with SendKeys - usually
a DoCmd.RunCommand ac<something>. See the online help for RunCommand
to see if you can accomplish what you want to do without using
SendKeys.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public