Quote Originally Posted by GaryB
Rather than using before hand, I used Enter and made the following changes and it works great.
Just FYI, using the code in the Enter means the code only runs when the control first gets focus. This means, the user can enter 500, tab to the next control and you wouldn't get the error message. Only if the control got the focus again would you get an error message.