Automatically Putting date in field

In the form I have a date field, is their a way in which I can make the date
field automatically but in todays date when opening each record.

Make the control source of the field

=Date()

"horseman" wrote:

In the form I have a date field, is their a way in which I can make the date
field automatically but in todays date when opening each record.

In the text box's Default Value Property, try:

=Date()

so that if the text box is bound, whenever a new record is created, "today"
is the date assigned, and if the text box isn't bound, "today" will be
displayed for every record.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.


"horseman" wrote:

In the form I have a date field, is their a way in which I can make the date
field automatically but in todays date when opening each record.

You can set the default of the field in the table to Date(), that way when
ever you enter data, directly to the table, or using a query it will insert
today date in this field.

--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



"horseman" wrote:

In the form I have a date field, is their a way in which I can make the date
field automatically but in todays date when opening each record.

Your question is unclear about whether you want the date to change to
today's date every time you view the record, or if you want to store the
date the record was created? If the former, set the Control Source for the
text box to =Date(). If the latter, set the Default Value to =Date(). You
have received both suggestions, but again, your meaning is unclear.

"horseman" wrote in message
...
In the form I have a date field, is their a way in which I can make the
date
field automatically but in todays date when opening each record.