Run this code:
Code:
Dim dt As Date = Date.Now

MessageBox.Show(dt.ToLongDateString())
MessageBox.Show(dt.ToShortDateString())
MessageBox.Show(dt.ToLongTimeString())
MessageBox.Show(dt.ToShortTimeString())
MessageBox.Show(dt.ToString("yyyy-MMM-d HH:mm:ss"))
Did the data change? Obviously not. There's only one Date value. Even so, all five messages looked different. Can you accept that it's possible to display the same value in multiple ways? The fact that Access displays dates to you in short format is irrelevant to everything except how those dates get displayed to you. They aren't stored in the database in short format. They are stored in the database as a number, which doesn't have any format at all. How slow do you think a database would be if it had to sort a column of dates and they were all strings in a particular format? Dates can be sorted easily because they are all numbers. When you query your database, the numbers in the database are used to create .NET Date objects, which are also numbers. There is no format. It's only when you display the value to the user that format is an issue, and how could the way the values are displayed by Access have any effect on that? It's your app. You decide how dates get displayed to the user.