auto date in new records

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.
 
G

Graham Mandeno

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top