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

Defaulting to today's date in field

P: 6
I have two tables - AudiovisualItem and Checkout. One Audiovisual item can have multiple checkouts, so it is a one-to-many relationship.

The checkout table has a primary key (autonumber), foreign key (from the AudiovisualItem table), and a date field. Everything works fine until I try to make the date default to today's date using the Date() function. It seems to want you to actually type something in the field in order for it to move to the next record. Is the problem that both the key field and date field are being automatically generated?

Thanks for your help!
Dec 14 '08 #1
Share this Question
Share on Google+
4 Replies


puppydogbuddy
Expert 100+
P: 1,923
It sounds like you put the Date() expression into the control source property of the control bounded to that field on the form instead of putting it in the field's default value property.
Dec 14 '08 #2

P: 6
The field is data type date/time -- then I used an input mask of short date. Then in the default value field I clicked on the drop down menu, and picked the date() function. If I take the date () function out, it works ok.
Dec 14 '08 #3

missinglinq
Expert 2.5K+
P: 3,532
If you want the textbox to default to the current date, why are you using an Input Mask? Perhaps you meant to put short date in the Format Property instead?
Dec 14 '08 #4

P: 6
I used the short date and an input mask. The input mask was so that the user could enter 08 for the year instead of 2008. Does that make sense?
Dec 15 '08 #5

Post your reply

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