Access 97中的表单中的条件格式 [英] Conditional Formatting in a form in Access 97

问题描述

嘿那里。我有一个子窗体的表单，如果字段大于引号，则字段需要为一种颜色，如果小于引号，则为另一种颜色;如果与引用的数字相同，则为白色。我已经在子窗体中直接尝试了以下代码，但它不起作用。还有什么建议吗？


私人子strRun_Rate_AfterUpdate（）

选择案例strRun_Rate.Value

案例是> strQuotedRate.Value：

Me.strRun_Rate.BackColor = 16744576

Case Is< strQuotedRate.Value：

Me.strRun_Rate.BackColor = 12615935

案例其他：

Me.strRun_Rate.BackColor = 255

结束选择

结束子


提前感谢您的帮助。

解决方案

< blockquote>使用格式菜单下的条件格式向导。你不能通过代码来做。

你也不能在Access97，Rabbit中做到这一点！不是条件格式化！

你也无法在Access97，Rabbit中做到这一点！不符合条件格式！

啊，好吧，我从来没用过97 lol。

我从2003年开始。

Hey there. I have a form with a subform that has a field that needs to be one color if the field is greater than the quoted number and another color if it is less than the quoted number and just white if it is the same as the quoted number. I have tried the following code directly in the subform but it did not work. Any other suggestions?

Private Sub strRun_Rate_AfterUpdate()
Select Case strRun_Rate.Value
Case Is > strQuotedRate.Value:
Me.strRun_Rate.BackColor = 16744576
Case Is < strQuotedRate.Value:
Me.strRun_Rate.BackColor = 12615935
Case Other:
Me.strRun_Rate.BackColor = 255
End Select
End Sub

Thank you in advance for any help.

解决方案

Use the conditional formatting wizard under the format menu. You can''t do it through code.

You also can''t do it in Access97, Rabbit! Not with Conditional Formatting!

You also can''t do it in Access97, Rabbit! Not with Conditional Formatting!

Ah, ok, I''ve never used 97 lol.
I started with 2003.

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