Hi to all,
I have an unbounded text box on a form and I want the user enter a date in it.
How can I validate that the value typed in the text box is a date?
Thank you.
Hi to all,
I have an unbounded text box on a form and I want the user enter a date in it.
How can I validate that the value typed in the text box is a date?
Thank you.
You can use
But you might want more than that as validation e.g. check it's a sensible date not 13/2/207 - which is a valid date.Code:If Not IsDate(Me.MyDateControl) Then ....
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Hi,
Thank you for the reply.