Mysterious field background colour change in Access 2007

Using:

     thisForm.Detail.BackColor = <whatever RGB trio>

I change the background (detail) colour of a form. That works. In some cases, however, some of the individual fields' background colour also changes to the same as the detail area of the form. These fields' background is not transparent, before you ask... And it only happens sometimes!

Any possible explanation?

Many thanks.
PeborghAsked:
Who is Participating?
 
McOzConnect With a Mentor Commented:
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Either:

1) Troubles with the database - Compact and repair the db. If that doesn't resolve it, move everything into a new, blank database

2) Troubles with Access/Office - are you fully updated? If not, try that. If you are, perhaps a repair or reinstall.

3) Troubles with Windows - are you fully updated? If you are, then it might be time to do some checking on that

4) Troubles with your video driver or card - are you sure the driver is fully up to date? There have been some odd reports of video troubles in Office with some higher end graphics cards. My own setup, which uses a very high end graphics card, sometimes does odd things while I'm working in Access (colors seem to modify themselves slightly, from a Red to a bit less deep red, for example).

If you move the db to a new machine and run it there, do the troubles follow the database? If they do, then you'd suspect troubles with the db. If they do not, then you'd suspect 2, 3 or 4.
0
 
PeborghAuthor Commented:
McOz, I set the alternate back colour of the detail of the form to black and bingo, problem went away...

Many thanks,

peter
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.