报表中的条件格式 [英] Conditional formatting in a report

问题描述

亲爱的，


我的报告中包含一些字段。如果Field2为> 0，我希望Field1的Allignment为左对齐，如果Field3为> 0，则为Right-alligned

注意：Field2和Field3都不可能同时>>。


这可能吗？

Dear all,

I have a report with some fields in it. I want the allignment of Field1 be Left-alligned if Field2 is >0 and Right-alligned if Field3 is >0

Note: It is not possible for both Field2 and Field3 to be >0 at the same time.

Is this possible????????????

推荐答案

我也想在子表单中做同样的事情。


有没有人知道怎么做？

I also want to do the same in a subform.

Does anyone have any idea how?

@ Alireza355

这可能吗????????????

Is this possible????????????

很有可能，它将在报告的详细信息部分的Format（）事件中完成，如：

It is very possible, and it would be done in the Format() Event of the Report''s Detail Section, as in:

展开 | 选择 | Wrap | 行号

你确定这个ADezii有效吗？


我原以为这会改变格式在页面格式化之前，控件多次。无论最后运行哪一个都将确定最终显示该页面的所有记录的控件。


基本上控件的格式与控件相关（仅限控件）一个例子。


除非你用 Format（）函数调用格式化每条记录的数据，否则我的答案是不可能的。 。这种方法有各种各样的缺点（控制格式并不简单;结果变成了字符串而不再是数字;等等），但我看不到其他方法有效。

Are you sure this works ADezii?

I would have thought this would change the format of the control a number of times before the page is formatted. Whichever was the last to run would determine the eventual display of the control for all records of that page.

Essentially the format of the control is associated with the control (of which there is only one instance).

My answer would be that it''s not possible, unless you formatted the data of each record with a Format() function call. There are various drawbacks to this method (Controlling the format is not straightforward; The result becomes a string and no longer numeric; etc), but I see no other way working.

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