I'm using Date Picker to input a date on a form and I've just noticed something odd.
The property sheet for this control shows the following format: mm/dd/yyyy
I'm happy with that formatting and that is how the dates are ultimately stored in the table. BUT ...
When selecting the date from date picker - that is, while in the form - the date appears as: dd/mm/yyyy
Is there any way to get the date appearing on the form to match the desired formatting I have selected in the property sheet? I'm surprised that the two don't match.
(PS I'm using ACCESS 2013)
The property sheet for this control shows the following format: mm/dd/yyyy
I'm happy with that formatting and that is how the dates are ultimately stored in the table. BUT ...
When selecting the date from date picker - that is, while in the form - the date appears as: dd/mm/yyyy
Is there any way to get the date appearing on the form to match the desired formatting I have selected in the property sheet? I'm surprised that the two don't match.
(PS I'm using ACCESS 2013)