combo boxes turn off Num Lock

[Dave]

Sometimes when i use a combo box, the NumLoc is turned off.

I gavn't been able to pinpoint the exact trigger for this yet,
I have only been able to narrow it down to combo boxes.

How can i stop this happening, or how can i turn it back on, once its off?

Any ideas would be appreciated

Thanks

Dave

 

[Van T. Dinh]

In some Access versions, there is a bug with the SendKeys Method and
SendKeys Macro action that turns the NumLock off.

If you do use SendKeys in your code, rewrite your code to remove the
SendKeys Method in your code.

 

[John Vinson]

Sometimes when i use a combo box, the NumLoc is turned off.

I gavn't been able to pinpoint the exact trigger for this yet,
I have only been able to narrow it down to combo boxes.

See if there is anything on the Events tab of the offending combo
boxes. If the combo calls a Macro or VBA code, check that code to see
if it includes SendKeys. The SendKeys operation is notorious for
messing up the NumLoc (and other!) settings, and should be avoided for
this reason.

 

[Greg Kraushaar]

Do you have long fingernails?
I recall a case back in DOS days when a tpyist would accidentally
knock the Numlock when she was going for the "7" key
We replaced quite a few keyboards brefore we twigged to the real
culprit >
Regards Greg Kraushaar
Wentworth Falls Australia
(Do not email - the reply address is a Spam spoofer)
(If you really must, remove all UCase and numbers)

 

[Dave]

Thanks for the reply

I use

On GotFocus Event

SendKeys "%{DOWN}"

to auto drop the combobox and that must be it.
It needs to be done though.
So I'll just have to tell the users to keep an eye out for it,
Unless anyone knows of another way to drop the combo box down ?

Dave

 

[Rick Brandt]

Thanks for the reply

I use

On GotFocus Event

SendKeys "%{DOWN}"

to auto drop the combobox and that must be it.
It needs to be done though.
So I'll just have to tell the users to keep an eye out for it,
Unless anyone knows of another way to drop the combo box down ?

Me!NameOfComboBox.DropDown

Just an FYI: There is *almost* nothing that you might think you need
SendKeys for that can't be done some other way. It's just a question of
finding out what that is.