In Access 2010 how can a text box default value equal todays date and a specific time?

I have an Access 2010 database with a form containing two unbound text boxes. I'm referencing the two unbound text boxes to specify from and through date/time criteria for a query. I'm trying to find a way to have the default value of the "from" text box to be yesterday's date at 7AM (Example: "9/23/2014 07:00:00 AM") and the through text box to have a default value of today's date in the same format. If I use the functions "=date()-1" and "=date()" as default values I get the dates I need, but I can't seem to find a way to get the 7AM time to appear. I tried using "=date()-1 " 07:00:00 AM"" but that just generates #type! error.
Brook_LaneAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
try

= date() - 1+ #7:00:00 AM#
0
 
Brook_LaneAuthor Commented:
That's exactly what I needed.. thank you! I can't believe how quickly you replied too!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.