Date

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

Guest

Hello,
I am designing a booking form. I have a Date field where a user will enter
the dates of bookings made. However to show the user to enter the date in the
UK style of dd/mm/yyyy I wish the field to show "dd/mm/yyyy" in the box to
show the user the format. I have tried putting "dd/mm/yyyy" in the default
value box but this gives an error becuase of my input mask needed
(00/00/0000;0;). Any Ideas?
John
 
Sorry im not sure if i understand what you mean, I tried changing the
'format' frim shortdate to'dd/mm/yyyy' but that didnt change anything if
thats what you meant
 
ok i tried that, however it still does not change it. Just leaves it blank.
Again when i try to put "dd/mm/yyyy" in default value it gives it as #error
 
If the table property that the Textbox is linked to is a date field, then it
will not like anything other that a date entered.

Have you tried putting a Controltip value in, such as "Enter the date as
dd/mm/yyyy" to direct the user?

Under textbox properties - Other - ControlTip Text.

Or a really messy solution...
Default value = Date()-100
Validation rule = >Date()-1
Validation message = "Enter a valid date in dd/mm/yyyy format"
This would cause a error if the user did not change the date

Make sure you put the validation rules in the table.
 
Ive seen such things on website before in registration processes. Box starts
with dd/mm/yyyy and when you click it, it disapears for you to enter the
date. It seems access cannot handle this so the control tip will have to do!
thanks
 
Back
Top