Access 2007 报告中的条件格式
我在 Access 2007 中创建了两个报表,除了数据源之外,它们几乎完全相同。在这两个报告中,我都在字段上设置了条件格式,以便
Expression is [Status]="Holding"
在其中一个报告中应用了条件格式而在另一个报告中没有应用条件格式时,使字体变为斜体。我什至尝试将其设置为
Expression is [Status]=[Status]
但条件格式仍然没有应用。关于出了什么问题有什么想法吗?
I have created two reports in Access 2007 that are virtually identical except for the data source. In both of them I have set up conditional formatting on a field to make the font italic when
Expression is [Status]="Holding"
In one of the reports the conditional formatting is applied and in the other it isn't. I've even tried setting it to
Expression is [Status]=[Status]
but the conditional formatting still isn't applied. Any ideas on what is going wrong?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
我清除了设置条件格式的所有文本框中的条件格式。然后我再次将条件格式设置为“
这次成功了!”很奇怪,但至少现在可以用了。
I cleared the conditional formatting from all the text boxes where it was set. I then again set the conditional formatting to
This time it worked! Very strange, but at least it's working now.
我发现这个有用的摘录 Office 网站:
I found this helpful excerpt on the Office website:
还要小心控件的“BackStyle”属性。如果您使用表单向导和默认样式模板,则背景样式可能是透明的 - 这意味着带有背景色的条件格式不会执行任何操作。
Be also careful with the 'BackStyle' property of the control. If you use a form wizard and default style template the backstyle may be transparent - which means that conditional formatting with a backcolor does nothing.