Date field default value

[Guest]

I have a date field in a table with the Data Type Date/Time. The format
property is set to dd/mm/yyyy. I would like the default value to be
"dd/mm/yyyy" so that users will know to enter the day before the month. I
can't seem to do this. I get 'an error "Type mismatch" in default value'
message. I can do this if the field is formatted as text, but not as
date/time.

Thanks.

 

[Al Camp]

Kokomojo,
No, a Date field will only except legitimate date values.
Place a label control to the right of your field like this
(Field label) (DateField) (Help Label)
MyDateField: 10/10/06 (mm/dd/yyyy)

Or use the ControlTipText property of your date field to display this
when the mouse is over the Date field.
My Date Field
(mm/dd/yyyy)

Given that the format for the field is mm/dd/yyyy, the user normally only
needs to enter a 2 digit year... not 4.
02 = 2002, 97 = 1997, etc...
You might consider showing them mm/dd/yy as the entry guide. Your call...