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

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

Post by RGFycmVsb » Wed, 22 Aug 2007 00:38:02


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.

Post by fred » Wed, 22 Aug 2007 00:48:53


"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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

 
 
 

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

Post by RGFycmVsb » Wed, 22 Aug 2007 01:04:00

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
 
 
 

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

Post by Rick Brand » Wed, 22 Aug 2007 03:13:04


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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
 
 
 

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

Post by John W. Vi » Wed, 22 Aug 2007 04:59:37

On Mon, 20 Aug 2007 09:04:00 -0700, Darrell



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]