2007 Access Combo Box changes Background color after tab through f

[terry beckman]

I have an 2007 Access form(s) that I just converted from 2003 Access. When
the client tabs through the combo box fields(no entry) the background color
changes to the color of the form. I tried to fix with code, but there seems
to be a system switch overriding this as the backgound color property is
correct.

Any help is appreciated.

Thanks!
Terry

 

[Jeff Boyce]

Terry

If the control changes color when it gets the focus, perhaps conditional
formatting was applied. Have you checked that?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[terry beckman]

Sorry I was not more specific. The color changes after focus is lost. I do
not have the issue in the Access 2003 version. This only seems to affect
combo boxes on 3 different screens in the Access 2007 database. I tried
fixing this with code and checked conditional formatting with no sucess.

Thanks!
Terry

 

[Jeff Boyce]

I'm at a loss, perhaps another newsgroup reader has run across this...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff G]

I ran into this problem as well. The way I got around it is, if it is the
Detail, check the Alternate Back Color. If it is set to No Color, click on
the drop down box and change it.

That should take care of it if it's a single form, not continuous.


Jeff G

 

[Dirk Goldgar]

I have an 2007 Access form(s) that I just converted from 2003 Access. When
the client tabs through the combo box fields(no entry) the background
color
changes to the color of the form. I tried to fix with code, but there
seems
to be a system switch overriding this as the backgound color property is
correct.

I haven't experience this myself, but I have seen discussions including
this:

http://www.access-freak.com/blog2008.html#BlogEntryMarch200801

And also this quote (from private communication): "It seems that regardless
of this setting, after having the focus and then moving the focus to
another control, the BackStyle goes Transparent if the section
AlternateBackColor is set to NoColor."

So you could probably address it either of two ways. In addition, this
seems the sort of thing that might be fixed in a service pack or hot-fix, so
I would make sure you have all Access 2007 SPs, and look for any post-SP
hot-fix that might refer to the problem.

 

[terry beckman]

Jeff, thanks much that solved the problem. I changed the alternative back
color to #FFFFFF and it no longer overwrote the combo box.
I wish this problem was documented or it should be fixed.

Thanks!
Terry