Access 2007 with SQL Server 2012 Date format problem
Posted on 2012-08-30
We have an Access front end that connects to SQL. We just upgraded from 2005 to 2012, and were happy to have a "Date" versus a "datetime" data type. We have converted all the dates to "date" in the migration.
However, now all the front end textboxes have format yyyy/mm/dd in the date being displayed.
We have tried to put the Textboxes to a format of "mm/dd/yyyy", but nothing is recognized.
Help! How do I get the Access textbox to display in "mm/dd/yyyy" with a SQL 2012 data type equal to "date"? We don't ever need time.