2003 SP3 - Drop Down Boxes

[Robert G Randall]

I read one posting that said the > or other such formats is what causes your
drop down box text to not be shown. I can't remove these as we rely on all
the data being in upper case for formality purposes.

I read another article that said the following hotfix fixes some of the
problems:

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

I looked it up and it says:
945280 Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install office 2003 Service Pack 3

I have not values visable, but they are there - does anyone know if this fix
is the answer to the problem? I don't want to go through the pain staking
process of unloading and reloading office - I have so much stuff in there!!!

 

[Allen Browne]

That hotfix should solve the problem.

Another futzy workaround is to create a calculated field for the display.
For example, instead of:
SELECT CompanyID,
CompanyName
FROM tblCompany;
try something crazy like:
SELECT CompanyID,
CompanyName & "" AS TheCompany
FROM tblCompany;

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Linq Adams via AccessMonster.com]

Wouldn't moving the formatting from table level to form/report level work?