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

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

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?
 
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?
Click to expand...

"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.
 
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
 
Darrell said:
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?
Click to expand...

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.
 
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?
Click to expand...

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]
 
Back
Top