基于列值的行级条件格式化 [英] Row level condition formating based on column value

问题描述

我希望整个行颜色根据报表中的列值进行更改。


敌人示例：从表1中选择名称，年龄，薪水 - 创建3行。


姓名年龄工资

A 15 1000

B 25 2000

c 35 3000

如果工资栏小于1001，第一行应为红色


如果工资栏低于2001，则第二行应为绿色。


如果工资低于30001，则第三行应为橙色。

如何在Msaccess2007中对整行进行条件颜色格式化。请帮助

Hi,
I want the entire row color to change based on a column value in a report.

Foe example: Select Name,Age,Salary from table 1 -cretes 3 rows.

Name Age Salary
A 15 1000
B 25 2000
c 35 3000

First row should be in red if Salary column is less than 1001

Second row should be green if Salary column is less than 2001.

Third row should be orange if salary is less than 30001.
How to do conditional color formatting of the entire row in Msaccess2007. Please help

推荐答案

您可以在on render事件中设置详细信息部分的背景颜色。

You can set the background color of the detail section in the on render event.

您也可以采取看一下这个帖子：
http：// bytes .com / topic / access / answer ...当前记录

Also you can take a look to this thread:
http://bytes.com/topic/access/answer...current-record

据我所知条件格式仅适用于'正在检查中，因此可能需要Mihail提供的链接。

As far as I know Conditional Formatting only works on the field that''s being checked, so the link Mihail provided is probably required for your need.

这篇关于基于列值的行级条件格式化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！