Text Box on Form - Query Date Format Problem

razorking

Registered User.
Local time
Today, 04:09
Joined
Aug 27, 2004
Messages
332
I have a form for data entry - and have an unbound text box on the form - formatted as short date. So on the form it has the calendar control to select the date (this is Access 2013). See attached - checkout.

Now I want to use a query to retrieve the values on the form - see attached - Query1

When I run the query everything pulls in as hoped except the date checkbox. It appears blank - if I place my cursor in the field I see odd characters. I assume there is a way to pull the date as it appears on the form - just not sure what I am missing. See attached - Query1Results

Thanks!
 

Attachments

  • checkout.png
    checkout.png
    8.7 KB · Views: 135
  • Query1.png
    Query1.png
    22.2 KB · Views: 123
  • Query1Results.png
    Query1Results.png
    9.7 KB · Views: 123
Figured it out - if it helps anyone else out: needed to be:
dateout: CDate([Forms]![CheckOut]![dateout])
 

Users who are viewing this thread

Back
Top Bottom