Frustrating Backcolor issue

[Hugh self taught]

Hi All,

On my forms in the database I'm working on, all the combo boxes backcolor
are transparent on moving focus to another control. No matter what I try I
can't get it to stay the set backcolor whether I leave it as default or set a
color. The moment focus moves out of the combo box it's backcolor is that of
the form detail. Am I missing something?

 

[oldblindpew]

I'm probably misunderstanding your question, but it sounds like you need to
set the combo box's Back Style from Transparent to Normal. If set at
Transparent, it doesn't matter what Back Color you specify, the underlying
color will show thru.

Regards,
OldBlindPew

 

[Hugh self taught]

Hi,

That's what's so frustrating. It is set on normal with all the defaults
white back black for etc. When it has the focus the color display is correct
but as soon as it loses the focus it behaves as though it was transparent.
This is happening on 2 forms in the same database. I eventually found though
that if I set the alternate color of the form to white then white is still
the backcolor after the combo loses focus. Strange & not right. Could mean a
corruption in my database?

 

[oldblindpew]

Is there some sort of event procedure that is making the Back Style change?

 

[Hugh self taught]

Nothing at all that I've done or can see in the properties. The only thing
I've done is give the form some backcolor & set the forecolor of the combo. I
wanted the back to stay the default white.

If I could understand I could accept but not knowing is killing me.

 

[oldblindpew]

You said "Nothing...in the properties." I'm assume you looked for an event
procedure (like On Got Focus or On Lost Focus) in the Events tab of the
Properties sheet for the Combo Box in question, and are not just confining
your search to the Format tab.

I still think there must be some setting (goodness knows they are plentiful)
that is responsible for the combo box behavior.

Q: Is this a regular form or is it a continuous subform?
Q: Are other controls, particularly Text Boxes behaving normally?

I assume you are aware that Alternate Back Color means "Alternating", not
"Alternative" color, i.e., for shading every other row. I haven't used this
feature, so mine are set to No Color.

Have you tried creating a new combo box (or text box) on the form just to
see how it behaves?

If you can find a control that behaves as desired, I would print out or
write down every setting you can find for it, and then compare them one by
one against the settings for the misbehaving combo boxes. If the controls
reside in different forms or sections, check the section settings as well.
I've been burned before by some little setting tucked away somewhere,
thinking it couldn't possibly have anything to do with my problem, and it
proves to be the key.

I've also been burned by putting a form into design view, changing a format
setting, then switching immediately back to form view only to find my change
was not implemented because I did not move the cursor after I made the
change, so the color (or whatever) reverted back to it's previous state
before editing.

Sorry I can't be of more help, but I'm relatively new to this.
Pew

 

[Paul Shapiro]

Not sure about this, but you could try changing the option setting for Use
Windows-themed Controls on Forms. In Access 2007 (not sure what version
you're working with) it's on the Current Database options page.

Have you tried creating a new blank db and importing everything from the
problematic db? That can either eliminate or at least indicate any
corruption issues.

Any chance you have conditional formatting active?

 

[JamesJ]

If you're using Acess 2007 you need to set the Alternate Back Color of the
Details
section to some color other than No Color.
Seems to have worked for me.

James

 

[Hugh self taught]

Had to be something. Thanks a stack Linq