Revision history [back]
 | 1 | initial version |
You can establish a particular date format in MS Access using VBA by setting the Format property of the desired control to the desired date format string. For example, if you want to display dates in the format "dd/mm/yyyy", you can use the following code:
Forms("MyForm").Controls("MyDateControl").Format = "dd/mm/yyyy"
Alternatively, you can also set the default date format for the entire database by going to File > Options > Object Designers, and entering the desired format string in the Default date format field. This will apply to all date controls in the database, unless their Format property is explicitly set to a different value.