Combo box date format

R

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.
 
K

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?
 
R

RobGMiller

rgmill
--
RobGMiller


Ken Snell (MVP) said:
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?
Click to expand...
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Combo box date format changes when item selected from list 4
Date Format - simple question 1
Display billing month based on start date and end date 5
Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Medium Date format and calendar in Access 2007 1
How to add day to PWA 2016 date format? 0

Top