Problem with a combo box (1 Viewer)

[keving]

I have a combo box pulling three columns, Primary Key, Request and Name. The properties box has a column count of 3 with column widths set to 0,1,1. The Combo box works perfectly under Access 2000. My problem is the combo box displays a blank column in Access 2003?? The Request column appears blank while the name column displays the Name correctly. I have attached an example the the ZIP file.

Thanks for the help in advance

 

[ezfriend]

Try convert your DB to 2002-2003 format and see if that help.

 

[keving]

Thanks for your help. I converted the database but the problem did not go away??? There must be a difference in how a combo box is setup between Access 2000 and Access 2003. Agian thanks for your reply.

 

[ByteMyzer]

Attaching a screen snapshot is all well and good, but without seeing the actual database, we can only guess as to the cause.

Do you have a sample copy of the database you can ZIP and attach for us to look at, in A2000 format?

 

[boblarson]

Actually, if it worked in the other environment but not in the 2003 environment then you probably have 2003 SP3 which has an issue if there is any formatting going on at table level.

I would apply this hotfix but also you should just go remove the formatting on the fields at table level.