form question-auto date?

[darklite]

I'm not sure how to ask this question. I know almost 0 VB, but I'm wondering if the following is possible:



I'm an Amazon seller and use a database to auto-send confirmation emails. On my table I made the text field a memo. Is it possible to have the date automatically filled in so I don't have to type it in?

Normally, I just highlight and copy the text, and click a link to the email section of amazon. Is it possible to write the code to automatically select and copy and insert the daily date? Thanks!

[michaeljohnh]

If you're viewing a table in Design view, click on the field that you want to contain the date and at the bottom under Field Properties under the General tab the Default Value should be set to Now() or Date(). That will autopopulate the field with the current date and or time depending on which you use.

[darklite]

Thanks, but when I do that, and I open the form, all it does is fill the field with this: Date() instead of the actual date. In the table in design view, I go to the general tab (I only have one field), under default I typed in Date().

[Access_Blaster]

the Default Value should be set to =Date() or =Now()

[darklite]

Perfect, it works perfect thanks to you and Michaeljohnh for the help in getting me started. BTW, is it possible to have the date start on the following day?