I need to show date in format dd/mm/yyyy

[zx3]

Hi All,



I m working on a project where the table has a date field with format set as dd/mm/yyyy, and i have a combobox which i populate it with the dates from the table, when clicking the combobox on the form, the dropdown listed the dates correctly as dd/mm/yyyy, but when a date is picked, the date turn into a shortdate (mm/d/yyyy), i tried setting the format of each combobox thru its properties page, and i tried setting it thru code but no luck.

All i want is to have date format consistency showing as dd/mm/yyyy when a date is picked, please help.

[June7]

Review http://allenbrowne.com/ser-36.html

If you are developing this db to run on computer with system date set as dd/mm/yyyy, then must develop in that same environment.

International (i.e. non-standard) date is common topic in forum. Might search and look at the discussions.

[A S MANN]

In control panel > Regional Setting > Custom Setting > Date . Set short Date Format as dd/mm/yyyy & apply setting
This will change All date format including Combo Box as dd/mm/yyyy.

[zx3]

Finally, i figure it out myself, just use the code to fix the display on the combobox, wrap the code below in the combo1_change sub
Me.Combo1.Value = Format(Me.Combo1.ItemData(0), "dd/mm/yyyy")

Thanks June7 and A S MANN too for the info.