Inserting Date in form

  • Thread starter Thread starter Heather Fabries
  • Start date Start date
H

Heather Fabries

Access 2003

I have inhereted a form and one of the fields should enter today's date
automatically. It is not doing it. I right clicked on the text box in
design view, went to Properties, but I don't know what to do from there. Any
help would be appreciated.

Heather Fabries
 
Heather,
Locate the DefaultValue property of the text control (must be a Date/Time
field as defined in your table)
Place this value in the DefaultValue...
Date()
If you need to capture Date and Time...
Now()
On any NEW record, today's date will be entered automatically.
DefaultValue has no effect on previously entered records.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Set the text box's Default Value property to:
=Date()

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Back
Top