I have an Excel database with dates in the format
dd/mm/yyyy. If I select the Data | Form option from the
standard menu bar, the dates look fine. If I activate the
DataForm through VBA with the above command, the dates
display as mm/dd/yyyy. I can overwrite the date using the
Data Form in the correct format, then scroll back to that
record and it still displays as mm/dd/yyyy. Underlying
data is fine, just the display on the Data Form when
called using VBA is incorrect.