Microsoft Access Default Value

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

Guest

Hi,

I would like to set a 'default value' in a table that updates feild with the
'current year only'!

Thanks
 
Charlie

A matter of definitions ... in Access, a "default" value is what Access
inserts into a new record. Default values don't "update" fields.

If you need to update a field for a number of rows, use an update query.

I'm not quite clear on what you are trying to accomplish -- can you explain
it a bit more?
 
What i would like to be able to do is set a default value to the current year
for example "2004"

Thanks
 
Hi Duane Hookom,

When I enter this =Year(Date()) it displays this date 26/06/1905
If Possible i would like to be able to just show the current year

Thanks
 
That makes sense to me since the displayed date is probably the 2004th day
beyond Dec 30,1899. If you want to just store the year, set the data type to
Long Integer and format it as general number with no decimal places.
 
Try setting the field's data type to Date/Time, its default value to =Date(),
and its format to yyyy.
 
Back
Top