By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Convert NOW()

P: 2
I need to convert the system date NOW() in an Access database field to a static date. The field shows the system date, but whenever the record is opened again it naturally reflects the current date. I need to have the system date picked up, then copied as a static value in the same field. I need to perform calculations based on the static date. Help!!

Thanks
McDee
Aug 10 '06 #1
Share this Question
Share on Google+
2 Replies


100+
P: 179
Is the textbox's Control Source assigned to the field in question (Do not use =NOW for the Control Source of the textbox). Using the OnFocus Event for the textbox, you can use the following code:

Me.textbox1=NOW()

This will assign the current date to the textbox only when it has focus.

Not sure if this is what you're looking for.
comteck
Aug 10 '06 #2

P: 2
I'll give that a try, thanks, I'm no expert here (obviously)!

McDee
Aug 10 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.