Supress onscreen "Num Lock" display

[Rokkit]

I use

SendKeys "{tab}"

a few times within my program. Whenever SendKeys executes, it sends the current status of Num Lock on the screen. It doesn't change from Num Lock on or off, it just displays the status.



I can turn off this function from the control panel, but it will turn off Caps Lock and Num Lock permanently, which I'd prefer not to do.

It doesn't affect the operation of the program, but it's annoying to see the Caps Lock indicator flash on screen.

Can this be disabled via VBA?

TIA

[RuralGuy]

SendKeys is one of those commands that does not always work as expected. Why are you sending a tab? What do you expect to happen? Maybe there is another way to achieve the same results without using SendKeys.

[Rokkit]

I use it for when opening a form and dropping down a list. When he form loads:

Private Sub Form_Load()
Me.Check272.SetFocus
SendKeys "{tab}"
End Sub

which tabs over to a combo box

Private Sub Find_a_Customer_GotFocus()
Me![Find a Customer].Dropdown
End Sub

[Peter M]

Why aren't you using Me![Find a customer].setFocus ?

[Rokkit]

Because the combo box will not drop down (I just verified that - again). The only way I can get the box to drop down on page loads is to tab over from another field.

[Peter M]

Try
Me![Find a customer].setFocus

And then under the Event Action Got Focus:
Me![Find a customer].DropDown

This should cause the Combo Box to open when it has focus. (If you want the combo box to just start open, you can do it without setting the focus.)

[Rokkit]

I've been there and done that (and just re-verified that again, too!) For some reason when the form loads it will not execute the dropdown command if the SetFocus begins on the dropdown field. I have to tab to it. Even OnDirty.dropdown command does not work if the dropdown is the field that has focus when the form loads.

Thanks for the suggestion, though