Dates are not displayed in ComboBox

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

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
 
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
 
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--
 
Back
Top