Microsoft Forms 2.0 Listbox Control

[sogibear]

Hello,

Regarding the ActiveX Control (Microsoft Forms 2.0 Listbox), i've got it working fine except all dates in the listbox display are in the American format i.e MM/DD/YYYY.
I actually need it to use the format : DD/MM/YYYY

the rowsource for the list returns the date in the DD/MM/YYYY format which is great, but then when i assign it too the listbox in code the format changes ??

Any help would be appreciated

Thank-you

 

[FancyPrairie]

When you assign it to the list box in code, you will probably have to use the format statement (Format(dte,"dd/mm/yyyy&quot)

 

[sogibear]

Thanks,
however I am basing the listbox on a recordset which is then assigned to a two dimentional array like so, this array is then assigned to the listboxes column property.

Dim varlist as variant
Dim rstList As ADODB.Recordset

varList = rstList.GetRows
Me.AcXlstPreviousAssessments.Column = varList

the date values whilst in the array are correct, the problem is that when the arrray is assigned to the listbox's column value the date are weirdly formatted to the "mm/dd/yyyy"(wrong) format.

HHmmmmm ?