Very true, Jim. Users will Ctrl Alt Delete their way out of the painful
experience and refuse to touch it ever after.

Best wishes Harald

"Jim Thomlinson" wrote in message
...
While I am not saying don't do what you are planning on doing, I have
found
that users don't like mandatory fields that they can not get out of. IMO
you
are better off to catch where they have exited the input without entering
anything and letting them know the consequences of leaving that field
blank.
Then allow them to try again ro whatever is needed...
--
HTH...

Jim Thomlinson


"Ewing25" wrote:

That works great! thanks!

"Gary Brown" wrote:

Do While MyValue = ""
MyValue = InputBox(Message, Title)
Loop

...will keep the inputbox showing until something is entered.