You could check the Exit event of say textboxes, but that assumes they
enter. Best to also check on submit.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike" wrote in message
...
Is there an easier way to force users to enter values in a field on a
userform than doing a test on the value after the form has been submitted?

Thanks
Mke