Dates are not displayed in ComboBox

[ryguy7272]

I have a From ComboBox and a To ComboBox on a Form; cboFrom and cboTo. The
Row Source is this:
SELECT DISTINCT SharePrices.DateTime FROM SharePrices ORDER BY
SharePrices.DateTime;

The SQL is this:
SELECT DISTINCT SharePrices.DateTime
FROM SharePrices
ORDER BY SharePrices.DateTime;

Nothing is showing in either ComboBox; all I see is a whole bunch of blanks.
I just did this in another form in another Access database. I can’t figure
out why it’s not working for me now. I’m using Access 2007.

I’d sincerely appreciate any insight with this.

Thanks!
Ryan

 

[Paolo]

Hi ryguy7272,

in the properties of your combos check the column count that must be at
least 1 and the column widths that must be <>0.

HTH Paolo

 

[ryguy7272]

Ah! That was it! My Column Count was set ti 1, which was fine, but my
Column Widths were 0";1", which was not right. I changed Column Widths to
1", and it works fine now. Thanks so much!!
Ryan--