That worked as well as placing code to put the dates in the text box on loading
of the form.
Thanks!
Dave
-----Original Message-----
From: ms_access@yahoogroups.com on behalf of Dawn Crosier
Sent: Fri 9/15/2006 1:24 PM
To: ms_access@yahoogroups.com
Cc:
Subject: **SPAM**RE: [ms_access] Automate text box with readable date
The problem may be that =Now() returns a date and time value. Perhaps
=Date() would work better for you.
I would add =Date() to the default value of the textbox.
Dawn Crosier
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and
questions to
the newsgroup so that others can learn as well.
-----Original Message-----
From: ms_access@yahoogroups.com <mailto:ms_access%40yahoogroups.com>
[mailto:ms_access@yahoogroups.com <mailto:ms_access%40yahoogroups.com> ] On
Behalf
Of memairport
Sent: Friday, September 15, 2006 12:23 PM
To: ms_access@yahoogroups.com <mailto:ms_access%40yahoogroups.com>
Subject: [ms_access] Automate text box with readable date
If I want to automate a text box with today's date to be used in a
query how
would I do that?
I have placed =now() for a date to be automatically placed in the box
when
the form opens but the query does not see the date. It is as if the date
has not been entered even though it shows up. I tried placing the =now()
formula in the before update section of the text box properties, and
have
tried placing the formula in the text box itself, but the query still
does
not pick up the date and returns an empty report.
Any idea on how to get the text box to update itself when the form
opens so
the query can see the data as a date?
Thanks!
Dave
This e-mail and any attachments may be confidential or legally privileged. If
you receive this message in error or are not the intended recipient, you should
destroy the e-mail message and any attachments or copies, and you are
prohibited from retaining, distributing, disclosing or using any information
contained herein. Please inform us of the erroneous delivery by return e-mail.
Thank you for your cooperation.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
