I'm trying to code to alter my field (Modified) with a Data Type of Date/Time in my table (Documents) to be Short Date but seem to find the correct syntax. My statements reads as follows:
CurrentDb.TableDefs("Documents").Fields("Modified" ).Properties("format", "Short Date")
What's the correct syntax?
Thanks!