not default

[rob peterson]

I have a form with an unbound text box for entering beginning date. Mask is
99/99/0000;;_

Default value is 12/31/1999. (just for an example). The field is text. (I
couldn't get it to work with datefield format - when I tried, access said it
was too complex to run).

Anyway, when I call up the form, the field is full of numbers.
1233131413414141414 like that.
I can type over them and the mask shows up and lets me put in a date, but
what can I do to just have the default date show up.

thanks.

 

[Guest]

Hi Rob

The input mask should be
00/00/0000;0;_
You have one too many semi colons

Try deleting the mask on your field then re-formating it to a date and then
set the input mask as above

Hope this helps

 

[Guest]

Your field in the table should be a date/time. How did you enter the default
date? A text field will allow the value you show. The input mask just
limits how the data is entered. When I enter #12/31/1999# as a default value
in a date field, I have no problems at all. Your problem is using a text
field to store a date.