Even if you did this, it would have no effect on how the date would be interpreted by Access.
Why not let the user enter the date any way they want to and just format it as "dd/mm/yyyy" (or better, as "dd/mmm/yyyy", so that there is no confusion between day and month)
I have done. I would like the text box to have 'dd/mm/yyyy' written in it when I move to it.
I would then like to to enter the date and have it appear instead of the 'dd/mm/yyyy' is it possible to do this?
from help file
Dim MyDate, MyShortDate, MyTime, MyShortTime
MyDate = "February 12, 1969" ' Define date.
MyShortDate = CDate(MyDate) ' Convert to Date data type.
MyTime = "4:35:47 PM" ' Define time.
MyShortTime = CDate(MyTime) ' Convert to Date data type.
or
FormatDate Function
FormatDateTime(Date[,NamedFormat])
________________________________________________________________________
Zameer Abdulla Visit Me Children are poor men's riches.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.