SendKeys is a very tricky action, known to produce unexpected results once
too often, and should be avoided if at all possible. Chances are whatever
you are trying to do with it can be done in a much more robust way, so my
advice is post to seek help with how to do it without resorting to SendKeys.
Nikos
Thanks for your advice which I'll probably take on board. Reason for asking
is that I'm working on someone else's Access system which is using SendKeys
(which I might change following your advice) but it would be nice to know
what the SendKeys action is supposed to be doing.
It does just waht the name implies: it has the same effect as if you were
pressing specific keys (the argument) on the keyboard, so "a" will send an
a, "^C" is Ctrl+C (copy) etc. For a complete list, open Access help and look
up SendKeys Statement in the Answer Wizard.