Text Box on Form - Query Date Format Problem

mercredi 8 avril 2015

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!




Attached Images













File Type: png checkout.png (8.7 KB)
File Type: png Query1.png (22.2 KB)
File Type: png Query1Results.png (9.7 KB)



Text Box on Form - Query Date Format Problem

0 commentaires:

Enregistrer un commentaire

Labels