Problem with combo boxes

[U226RM2]

Until fairly recently, I was using Access 2000 and then got upgraded to 2003. Everything was working OK until last week, when I went to enter some data and discovered that some combo boxes on certain forms have no information in them. The databases work fine on any machine that runs Access 2000. I have tried converting to 2003 format and redoing the combo boxes but that hasn't worked.

Any suggestions gratefully received!

 

[RuralGuy]

When SP3 has been applied to Access 2003, a combobox will go blank if its RowSource is a table and it has something in its Format property. The workaround is to remove anything from the Format property of the ComboBox. You might also try using a query instead of a table.

 

[U226RM2]

Any other suggestions??

Thanks RG. The format property is empty so I tried your other advice and redid the combo box to look up data from a query - the combo box is still blank! (The query works on its own though)

 

[KenHigg]

I think you have a column width set to 0"

???
ken

 

[RuralGuy]

Is there anything in the Format property for that field in the table?

 

[U226RM2]

Hey sorted!

RG, I was just about to post a reply saying I just sorted it by checking the format property in the table rather than the combo box. Thanks, thanks, thanks!

Ken - OK, I was dumb but not that dumb!!

 

[RuralGuy]

Glad you got it sorted and you are welcome.

 

[RuralGuy]

Ken - OK, I was dumb but not that dumb!!

I've been that dumb!

 

[KenHigg]

I've been that dumb!

Me too -

(Sorry )
ken

 

[U226RM2]

Ha ha

Helpful and funny! Thanks guys, problem solved and a laugh this morning. Is everyone on the forum like this or did I just get lucky with my first thread?!