Date

[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

 

[Guest]

Did you try the format propety of the field with
dd/mm/yyyy

 

[Guest]

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

 

[Guest]

I ment in the text box in the form, to change the format.

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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