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: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of memairport Sent: Friday, September 15, 2006 12:23 PM To: [email protected] 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 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/
