auto date in new records

  • Thread starter Thread starter Geraldine Barker
  • Start date Start date
G

Geraldine Barker

In Excel, you can get the system to emit the current date
with a control or alt and some other key - can't remember
what. Is there a similar trick with Access? I'd like to
have all the entries for one day identified as a way to
age membership. I have looked at "expressions" but as a
fairly inexperienced (and self-taught) user, I don't
understand what I'm reading. Thanks for your help.
 
Hi Geraldine

Ctrl-; (semicolon) will insert the current date in a textbox on a form.

However, it might be better to set the DefaultValue property for the textbox
to:
=Date()

This will automatically put the current date into that field for all new
records.

Changing this to =Now() will record the date *and* the time.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.
 
Back
Top