2003 SP3 - Drop Down Boxes

R

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!!!
 
A

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]...
 
L

Linq Adams via AccessMonster.com

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top