Winnebago
asked on
Invalid Character Msg when using SendKeys
I am using a drop downlist where the user enters a birthdate. If the birthdate is not in the list, I would like to use sendkeys "{esc}" in the not in list event. I am getting the message "invalid character". Could anyone let me know what I am doing wrong? Thanks
Why don't you try setting focus to next control?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I couldn't get the other solutions to work, so I did something similar to your solution:
If MsgBox("No matches were found for the date you entered.", vbOKOnly) = vbOK Then
Response = acDataErrContinue
ctl.Undo
End If
Thanks for your help.
If MsgBox("No matches were found for the date you entered.", vbOKOnly) = vbOK Then
Response = acDataErrContinue
ctl.Undo
End If
Thanks for your help.
sendkeys "{ESC}" ,true
Thanks
Jell