条件格式访问2007 - 报告 [英] Conditional Formatting Access 2007 - Reports

问题描述

我正在整理一份报告（一个非常简单的报告），我按犯罪类型（所有，暴力，财产）进行分组，显示城市和地区数据的百分比变化。我需要根据犯罪类型格式化场背景颜色（即浅红色用于暴力，淡绿色用于属性，淡紫色用于所有）并且还希望将百分比变化字段中的文本格式化为红色（如果为正）（犯罪率上升） ）如果是负面的，则为蓝色（犯罪率下降）。


我可以做任何一个或通过条件格式化按钮，但我不知道如何做到这两点。我希望我错过了明显的东西，因为我不是一个访问大师（我是统计学家 - 让事情变得漂亮不是我常用的包，但有人递给我带有条件格式的excel报告并要求我自动化它）。提前感谢任何和所有的帮助！

I''m putting together a report (a very simple one) where I''m grouping by crime type (all, violent, property), displaying city and district data with percent change. I need to format the field background color based on crime type (i.e. pale red for violent, pale green for property, pale purple for all) and also want to format the text in the percent change field to be red if positive (crime went up) or blue if negative (crime went down).

I can do either or through the conditional formatting button, but I can''t figure out how to do both. I''m hoping I''m missing the obvious as I''m not an access guru (I''m a statistican - making things pretty is not my usual bag, but someone handed me an excel report with the conditional formatting and asked me to automate it). thanks in advance for any and all help!

推荐答案

我没有得到问题Liz。一个控件有一个设置使用条件格式，另一个控件有一个单独的控件也使用条件格式。问题在哪里？

I don''t get the problem Liz. One control has one setup using Conditional Formatting, and the other control has a separate one that also uses Conditional Formatting. Where''s the problem?

抱歉不清楚 - 我正在格式化报告行中的所有字段，使其具有基于犯罪类型的相同背景颜色并希望字体在28d％字段中也可以根据消极或积极形式进行格式化。


犯罪率28d％

所有城市-12.3％

暴力城8.2％

物业城-18.4％



如果条件格式化部分有6个选项，那就没问题了。我很确定我需要编码，但我不知道在哪里/如何。我在其他语言/软件包的编程方面还不错，但对access / sql / vba不太熟悉。

Sorry for not being clear - I''m formatting all the fields in the report row to have the same background color based on crime type and want the font in the 28d % field to also format based on being negative or positive.

Crime Area 28d %
All City -12.3%
Violent City 8.2%
Property City -18.4%

So the above would be purple across the first row, with -12.3% in blue font, pale red on the second row with 8.2% in red font and green on the last row with -18.4% in blue font.

If there were 6 options for the conditional formatting section it would be fine. I''m fairly sure I need to code it, but I can''t figure out where/how. I''m decent in programming in other languages/packages, but just don''t have much familiarity with access/sql/vba.

我担心三个选项是限制条件格式 Liz :-(


如果您需要应用逻辑来区分六个不同的条件，那么我甚至害怕获得良好的编码技能没有帮助，因为范围不存在。

I''m afraid that three options is the limit with Conditional Formatting Liz :-(

If you need to apply logic to differentiate between six separate conditions then I''m afraid even good coding skills won''t help, as the scope just isn''t there.

这篇关于条件格式访问2007 - 报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！