Combo box date format

[RobGMiller]

Access 2003.

How to format a date in the text property of a combo box.

Setting the format property to dd-mmm-yy or Medium date always returns
xx/xx/xx even though the row sources is formatted to dd-mmm-yy with the
output of a query.



Thanks.

 

[Ken Snell \(MVP\)]

Are you setting the Format property of the combo box itself on the form? Or
of the field to which the combo box is bound?

What is the query that you're using as the combo box's Row Source? Post the
SQL statement. Which field in that query is the date field?

 

[RobGMiller]

rgmill
--
RobGMiller

Are you setting the Format property of the combo box itself on the form? Or
of the field to which the combo box is bound?

What is the query that you're using as the combo box's Row Source? Post the
SQL statement. Which field in that query is the date field?

 

[RobGMiller]

Thanks for the clue Ken,

The answer is too simple.

If the combobox format field is left empty it displays whatever 'text' is
displayed in the pulldown list from the rowsource.

If the format field is set to any date format it displays the regional
settings date format as opposed to the date format that it is set to.