I've created a MS Access front end with a SQL Server backend. I've converted and linked the Tables I needed, but I'm having trouble with the default display of my date fields. Looks like the default format for SQL Tables is yyyy-mm-dd. I would like it to be mm/dd/yyyy. I've tried different date types (datetime, date, shortdatetime), but they all have the yyyy-mm-dd format. I've read about the Convert function, but does that permanently change the display on the SQL Table, or just in that query view? If there is not a way to change this default format, can I display it the way I prefer on the Access side (on the forms)?
Thank you for any feedback you can provide.