conditional formatting of a percent

[Guest]

I would like to use Conditional formatting on a percent field that is
calculated in my report. The text box field contains the formula
=[TotNot]/[TotEmp]. This field displays a percent on my report. I would
like to Highlight and Bold the percent if the field is greater then 50%. I
have had no luck with the things I have tried. Any suggestions?

 

[Allen Browne]

Using Conditional Formatting on the Format menu (in report design view), set
Condition 1 to:

0.5

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I would like to use Conditional formatting on a percent field that is
calculated in my report. The text box field contains the formula
=[TotNot]/[TotEmp]. This field displays a percent on my report. I would
like to Highlight and Bold the percent if the field is greater then 50%.
I
have had no luck with the things I have tried. Any suggestions?

 

[Marshall Barton]

I would like to use Conditional formatting on a percent field that is
calculated in my report. The text box field contains the formula
=[TotNot]/[TotEmp]. This field displays a percent on my report. I would
like to Highlight and Bold the percent if the field is greater then 50%. I
have had no luck with the things I have tried.

You can use Conditional Formatting (Format menu) on the text
box.
Field value is
Greater Than
.5

Or you can use a little code in the text box's section's
Format event procedure:

With Me.thetextbox
If .Value > .5 Then
.FontBold = True
.BackColor = vbYellow
Else
.FontBold = False
.BackColor = vbWhite
End If
End With

 

[Guest]

Thanks....that worked great!!
--
Tracy

Using Conditional Formatting on the Format menu (in report design view), set
Condition 1 to:

0.5

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I would like to use Conditional formatting on a percent field that is
calculated in my report. The text box field contains the formula
=[TotNot]/[TotEmp]. This field displays a percent on my report. I would
like to Highlight and Bold the percent if the field is greater then 50%.
I
have had no luck with the things I have tried. Any suggestions?