zagrijs
12-04-2012, 05:27 AM
Hi,
I am displaying dates from a spreadsheet in textboxes on a form. I prefer to use a date format that is known and commonly used in my counry, South Africa, i.e. yyyy/mm/dd.
My local settings are like that and the dates display correctly in a cell. However, when the cell is linked using controlsource or object.value = cell.value to a textbox on a form, the date is displayed in the American date format mm/dd/yyyy.
I know I can circumvent it by using something like object.value = year(cdate(range).value)) & "/" & month(cdate(range).value)) & "/" & day(cdate(range).value)), but would prefer to do it in a simpler way, if possible.
All help would be appreciated.
Regards
Zagrijs
:banghead:
I am displaying dates from a spreadsheet in textboxes on a form. I prefer to use a date format that is known and commonly used in my counry, South Africa, i.e. yyyy/mm/dd.
My local settings are like that and the dates display correctly in a cell. However, when the cell is linked using controlsource or object.value = cell.value to a textbox on a form, the date is displayed in the American date format mm/dd/yyyy.
I know I can circumvent it by using something like object.value = year(cdate(range).value)) & "/" & month(cdate(range).value)) & "/" & day(cdate(range).value)), but would prefer to do it in a simpler way, if possible.
All help would be appreciated.
Regards
Zagrijs
:banghead: