Coloring fiels on report

[Harmannus]

Hallo,

Is there a way to programm the color of a field on a report based on the
value of a field?

Thanx in advance for any suggestions on how to proceed.


Regards,

Harmannus

 

[fredg]

Hallo,

Is there a way to programm the color of a field on a report based on the
value of a field?

Thanx in advance for any suggestions on how to proceed.


Regards,

Harmannus

In Access 2000 or later you can use the Conditional Formatting
property off the control.
In Access 97 you ,would use the report section's Format event.

If you care to give a bit more information on your Access version and
what kind value is involved, I, or someone else, will be better able
to help.

 

[Jim/Chris]

In Access 2000 and greater you can use the conditional
formatting found at then menu bar Format/Conditional
Formatting. You can only use 3 conditions. If you have
more you will need to use code.

Jim