Auto Populate date on an Access form

[cazzi]

Hi,
I created an access form & would like a certain field to autopopulate
today's date when a new record is created. I tried placing =Now() in the
default value field under table properties that the form is linked to, but it
didint' work.

Please help!

Thanks,

 

[Jeff Boyce]

That depends on what you mean by "autopopulate"...

If you want to have every NEW record added to the table have a default value
of Now() (date PLUS time), what you did should work.

If you want to have every EXISTING record modified to include a date/time
value, you'll need to use an update query (or enter the correct values
yourself).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Hi,
I created an access form & would like a certain field to autopopulate
today's date when a new record is created. I tried placing =Now() in the
default value field under table properties that the form is linked to, but it
didint' work.

Please help!

Thanks,

For one thing, Now() does not return today's date; it returns the date and
time, accurate to milliseconds. You might want Date() instead if you just want
a date.

In what way did it not work? setting the default value should work either in
the table field or in the DefaultValue property of a bound control on your
form; as soon as the record is dirtied by entering anything into any other
field the default value should be invoked. What are you doing, and what is or
isn't happening?

 

[cazzi]

Thanks for your help- I actually only need the date & the Date() worked.

Thanks,

 

[cazzi]

Thanks for your help- I actually don't need to backtrack on any old data
since it's a new form. I tried it again using Date() & it worked.

Thanks,