Data not showing in combo box

S

Sheila D

I have a database which uses a combo box with 2 columns, in Access 2007 I can
see the information from both, in Access 2003 I can only see the data from
column 2, if I go to the SQL query and run that I can see both so I know the
data is there.

Strangely if I try in Access 2000 I can see the data no problem, This
database was designed originally in 2000 and has been running fine on all
versions untill now so I am baffled - any suggestions so my colleague can use
in 2003 would be much appreciated. I have tried on a 2nd machine with 2003
and still does not work.

Sheila
 
D

Douglas J. Steele

There was a bug in the recent service pack for Office 2003 (SP3).
Specifically, if you're using the Format property (as opposed to the Format
function) in the row source, the combo box acts as you're describing.

As far as I know, Microsoft is working to fix the problem, but I don't have
an ETA.
 
S

Sheila D

Thanks for quick response Douglas, I don't understand what you mean by using
the Format property in the Row Source, this is what I have:
SELECT TRANSINV.CLIENT, TRANSINV.I_NUMBER FROM TRANSINV ORDER BY
TRANSINV.I_NUMBER DESC;
What do I need to change to make this work in 2003 as well? I'm not using
the format property at all

Regards, Sheila
 
S

Sheila D

Indeed I had and if I remove it all is OK, what an extraordinary bug! Thanks
very much for your help
 
Top