Date inputs

[Dibblet]

On a form text box that contains a date I would like "dd/mm/yyyy" to appear in the text box as an input mask.

How do I make this happen?

 

[ZmrAbdulla]

Properties of the textbox, go to data tab and set the inputmask there.

________________________________________________________________________
Zameer Abdulla
Visit Me
Children are poor men's riches.

 

[lupins46]

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)

 

[Dibblet]

It is not clear it is a date. So I would like 'dd/mm/yyyy' to appear in the text box to prompt the user.

Can this be done?

 

[ZmrAbdulla]

Why don't you confirm what data type it is?

________________________________________________________________________
Zameer Abdulla
Visit Me
Children are poor men's riches.

 

[Dibblet]

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?

 

[ZmrAbdulla]

You may look into CDate Function

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.