I am trying to put in a default value for a date.

[Guest]

I am trying to put in a default value for a date. I want it to default to the
year something like "07"/__/__

Any suggestions?

 

[fredg]

I am trying to put in a default value for a date. I want it to default to the
year something like "07"/__/__

Any suggestions?

"07" is not a date, nor is 07, nor is 2007.
An Access date must be a complete date, including month, day,and year.

Why don't you re-think this message and tell us more clearly what you
really are trying to do.

 

[Guest]

OK

I want my default date to have 2007/__/__ when I enter data into a table.
What is the formula I would use in the design view under the Default value
line?

Thanks

 

[Rick Brandt]

OK

I want my default date to have 2007/__/__ when I enter data into a
table. What is the formula I would use in the design view under the
Default value line?

Sounds like what you want is an InputMask, not a DefaultValue. A
DefaultValue has to be a legitimate value and for a DateTime field that
would have to be a complete Date, not a partial one.

 

[John W. Vinson]

OK

I want my default date to have 2007/__/__ when I enter data into a table.
What is the formula I would use in the design view under the Default value
line?

If you type 8/20 into a textbox bound to a date/time field, Access will
automatically fill in the current year. No default value is needed, nor is any
code nor any input mask.

Sometimes it's simplest to do nothing... <g>

John W. Vinson [MVP]