We converted our split database back end to sql and went in and changed our date datatypes from datetime2 to date. In the front end all our dates are displaying yyyy-mm-dd. I went into the forms and set the format property of the control to short date and it does nothing, I formatted the date on the query, format(date,"Short Date"), but it locks the field of course. How do I get it to display the dates as short date, mm-dd-yyyy, other than vba coding every date field. There has to be an easy way I am missing.
Also the date picker is gone. Any help on both of these would be awesome.
Also the date picker is gone. Any help on both of these would be awesome.