[MS_AccessPros] Initialize Date Field to Today's Date

 

I have a simple form based on a query that includes a field ModifyDate.  When the form opens I want to initialize the ModifyDate field value to = today's date.

In the forms Open Event, I have tried:

  me.txtModifyDate = Date

 also me.txtModifyDate = Date() (and the VBE strips off the parentheses each time)

 and now() and Today()

 also txtModifyDate = Date (and Date(), Today(), Now()

It gives me error 2448; "You cannot assign a value to this object"

This should be very simple but I cannot figure out what I am doing wrong.

__._,_.___

---

Posted by: david.pratt@outlook.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___