access 2003 sp3 - combo - bug if PK is Text

[Alain Bourgeois]

Dear all,

I have a table profs with PK field Abbrev Text (length 5).
I have on a form an (unbound) combo box displaying abrev and other
field.

SELECT Profs.ABREVIATION, [Nom] & " " & [prenom] AS Expr1
FROM Profs
ORDER BY Profs.NOMNET;

Bound Column 1
Column count 2
Column Widths 7cm;1cm
List Width 9cm


In dropdown combo list, column abbrev appears as empty?????
(However, I can select a value).


Any help welcome.


Alain

 

[Jerry Whittle]

You say that the Abbrev field is the primary key; however, your query is
selecting the Profs.ABREVIATION. Do you also have an ABREVIATION field in
that table?

 

[Alain Bourgeois]

Sorry, abbrev field does not exist.
ABREVIATION text(5) is the pk.
column ABREVIATION appears as empty?????

 

[Alain Bourgeois]

OK Stop searching:
In table Profs, field ABREVIATION, format property: there was a >
(uppercase conversion) causing the problem. Removing it solves the
trouble.

Thanks anyway.

Regards.

 

[accesskastle]

I had noticed similar behavior with some of my comboboxes. With Access
2003/Office SP3, comboboxes/drop-down lists will display incorrect or blank
data where there should be data. Microsoft has a hotfix for this.

Download the hotfix at:

http://support.microsoft.com/kb/945674

AK
----------------------------------------

 

[pcbins]

I was so glad to finally find a fix for this. All of the databases I created
before the 2003 update are almost useless now.

However, I don't know what to do with this hotfix 945674. I have downloaded
it and extracted the files. Now what? How do i install this "fix" ?

Please help!