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

date/time field

Rebecca Ross
P: 9
My access db is defaulting the time in the date/time field to 12:00am always, how can I correct this to display the actual time?
Dec 29 '11 #1
Share this Question
Share on Google+
2 Replies


Seth Schrock
Expert 2.5K+
P: 2,931
You can set the default value of the control on the form/report or the field in the table to be Now(). This returns the current date and time. Then you just need to format it as a time field and it will show just the time.
Dec 29 '11 #2

Rebecca Ross
P: 9
Thanks so much, it works perfectly now....
Dec 29 '11 #3

Post your reply

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