IsDate & SetFocus

[tradinup2]

I'm trying make sure of a date entry in 2 textboxes.
I'm using the following code, the problem is the setfocus moves on to the next tabstop.

If I F8 thru the code the focus is set properly until it exits the sub.

Please Login or Register  to view this content.

thanks

[mikerickson]

Use the AfterUpdate event rather than Exit.

[tradinup2]

thanks, I'll give that a try as soon as I get in the am.

[tradinup2]

No, this doesn't seem to solve the problem, the focus still moves to the next text box.

[mikerickson]

Perhaps

Please Login or Register  to view this content.

[tradinup2]

Thanks Mike,
This is what I wound up with. For some reason I got "object required" with yours and I don't know why.
I appreciate the help, I would never have gotten there.

Please Login or Register  to view this content.

[mikerickson]

As you have it written, the With txtPurchaseDate and End With are not needed.

AHHH, I see your control is named txtPurchDate, no "ase"

Try

Please Login or Register  to view this content.