Strange conditional formatting behavior

[Keith]

I have a report that uses conditional formatting to change the font color of
a label to white (which in effect makes it invisible) when certain conditions
are met. This works just fine except that one computer has started to leave
the font color black when the report is previewed or printed, regardless of
whether or not the condition is met. This used to work fine on this computer
until recently. I have also noticed that on some Access forms the colors
don't appear as they should on this one computer. The computer in question
runs Windows XP Professional, and the Access version is 2000. Has anyone
else seen this behavior?

Thanks,

Keith

 

[fredg]

I have a report that uses conditional formatting to change the font color of
a label to white (which in effect makes it invisible) when certain conditions
are met. This works just fine except that one computer has started to leave
the font color black when the report is previewed or printed, regardless of
whether or not the condition is met. This used to work fine on this computer
until recently. I have also noticed that on some Access forms the colors
don't appear as they should on this one computer. The computer in question
runs Windows XP Professional, and the Access version is 2000. Has anyone
else seen this behavior?

Thanks,

Keith

That's not how to 'hide' a value.
What would happen if you printed on colored paper using your method?
You would have white text visible even though the criteria was met and
the report was working correctly.

Why not just make the control not visible if that same condition is
met?
Code the report section's Format event (that the control is in):

Me![ControlName].Visible = Me![OtherControlName]= some criteria

Also, different computer monitors render colors differently. That's
not an Access problem.

 

[Keith]

I solved my problem. The user had changed their accessibility options
display settings to high contrast. I understand why that changed the forms
appearance, but I don't quite get why it affected the appearance of a report.
Anyway, problem solved.

 

[Evi]

That certainly is weird!

I guess you want the empty control so that you can have a 'space' as part of
your list or so that the border of your control shows, rather than having
the list close up to hide the space.

Apart from exorcism (and if you decide on that, invite Neofax and his
database along), could you tackle this another way by replacing the control
with a text box with an IIF phrase in it which leaves a "" if the conditions
are met? So long as there is a "" in the box, its borders will still show/it
will still serve as a space holder but the viewer will see nothing in the
box. If the IIF phrase reads like War and Peace you may even have to write
a Function in a module which may sound daunting but can be easier than a
long nested IIF.

Evi