access 2007 some combo's won't keep same color formatting

[Ziggy1]

I have searched for this, but can't find a solution that works.


I have 3 combo's all of which were created the same way, the 3 were added at a later time. When I added them I used the format painter to copy over the same "Look" of all the colors... well only the first of the 3 keeps the color you see when clicking the drop down.

In the detail section of my form I have it set to alternate color, on the combos that work, the font fore color remains the same as when it is not clicked, but the highlighted line of the selected choice will light up the font to RED... which is good... BUT... on the non working combo the font changes to BLACK for everything in the list, the color of the bar is correct but the selected shoice turns the Font to White!!!! WTF, I have looked very closely at all the properties, there is no conditional formatting set... this is really annoying, I have my combos set to the perfect color.

 

[missinglinq]

A bug in 2007 sometimes effects Comboboxes in this way. A quick workaround, per Allen Browne, is to set the AlternateBackColor Property of the Section (Header/Detail/Footer) to something other than "No Color", e.g. #80000027.

The ultimate resolution is to install SP2 and apply this hotfix:

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

Linq ;0)>

 

[Ziggy1]

thanks, I have tried all that as those solutions have been described in the things I found through internet search, and I also have SP2?

I can post screen shots on the weekend

 

[Ziggy1]

Here is an example of how messed up it is. I completely re-did my lookups for this one combo.

I made the image a bit blurry to obscure data, but look at the columns, first and 3rd are the way I want it and the middle one is messed up? Now it is even worse, or partly better depending on how you look at it, but even more illogical!!!

 

[Ziggy1]

I even copied a working control then copy pasted the rowsource and controlsource, and the colors changed when I did so!!!

 

[Ziggy1]

here is my Access version