If you've tried solution and seen that it works, here's why I think
it does. -- is that English -- Hmmmmm....

The code  that's doing the work isn't in a text  box event  any more.

He's moved it to the default command button.

It's pretty neat really and removes the need to use ... Ugh ... Sendkeys.

I like both solutions but as I have 2 pages in the form and similar
arrangements on both then I'll probably go with the sendkeys solution.