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.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2023-06-22 21:00:21 +0000
Seen: 10 times
Last updated: Jun 22 '23
What is the method to locally access Files with JCIFS?
How to access HTML files stored on Google Drive?
How can several goroutines access a shared channel for reading data?
What is the appropriate response from the backend when a JWT token has expired?
What is the issue when navigating from a child fragment to a bottom navigation fragment?