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.
Date value in an unbound text box
Competent Performer
Windows 10 
Access 2010 32bit
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.
VIP
Windows 10 Office 365
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 ↓↓
Competent Performer
Windows 10 Access 2010 32bit
Hi,
Thank you for the reply.
How to add/update date from unbound text box on a form to a table
Force entry of date AND time unbound text box
Date Picker Option Not Available For Unbound Text box
Auto fill date into unbound text box
IIF formula in an unbound text box using date()
Posting Permissions
Reply With Quote