Drop down lists not showing data 1

[jeffshex]

I have an interesting one.
On some of our forms, we have drop down boxes that are populated by a query.
The strange thing is that I have one computer that when you click on SOME of the drop down boxes, no data is shown.
On other computers, they work just fine.
So I have tried a detect and repair, compact, and even reinstalled office on that machine and have had no luck.

Has anyone ran into this before or know what can cause this issue on one machine and not others?

 

[randy700]

Is the dropdown that doesn't work based on a table/query that is available to all users?

Randy

 

[jeffshex]

Yes, I have no security on it.
They can view the information from the query itself, it's just when it's in one of a couple certain drop downs.

 

[jeffshex]

Just an update. It seems to be caused by something in Office Service Pack 3.

Not sure what it is, but did a restore to SP2 and everything is working fine again.

 

[missinglinq]

SP3 causes this behavior if the field in the combobox has been formatted. The usual culprit, amazingly, is the simple > used to force upper case. Simply removing the formatting returns this particular functionality under SP3. Of course, they're a bunch of other bugs, so removing it until Micro$oft gets things sorted out was, IMHO, the way to go.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[combs]

This was the answer that I was looking for!! How maddening that MS takes something that's working fine and makes it a problem with their "Service Pack"!!

Also frustrating that it takes so long to find answers, but at least this place exists to find them.... Had to search for just the right topic - my fault I guess.