Quote Originally Posted by firefytr
Dan! Beautiful!

Maybe that's where I was going wrong, the help files said vbKeyTab value was 0x9, but I never put in just 9. Doh! Would you know why this doesn't work well with the KeyPress method? I error out if I change it?
From the help file:-



A KeyPress event does not occur under the following conditions:
  • Pressing TAB
  • Pressing ENTER
  • Pressing an arrow key.
  • When a keystroke causes the focus to move from one control to another.
I think the first condition is the answer to your question.

Regards,
Daniel