How validate a date and phone field value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write error checking code for date and phone fields that user type
values for. I have used the input mask too. But if the user doesn't
complete the input i want to write my own error message rather than use the
MS error message. Is there a function that I can use to validate the value?
I've tried code on several events but nothing seems to work.

Sorry if this question appears more than once. I've tried unsuccessfully 3
times to enter this in the discussion group today. Thanks!
 
VBAgroupie said:
I need to write error checking code for date and phone fields that
user type values for. I have used the input mask too. But if the
user doesn't complete the input i want to write my own error message
rather than use the MS error message. Is there a function that I can
use to validate the value? I've tried code on several events but
nothing seems to work.

Sorry if this question appears more than once. I've tried
unsuccessfully 3 times to enter this in the discussion group today.
Thanks!
Click to expand...

Look up Setwarnings in VB help.
 
Back
Top