Conditional Formatting of a label on a report

Desitech

I have a Label on a report with a check box from a table indicating True or False. I would like to have the labels that are true to highlight yellow using conditional foramtting. The False labels to remain unhighlighted. I have tried changing the label to a text box and then conditional formatting "Expresion Is" "BILL"=TRUE. But the formatting is not working. I loose my Label text and BackColor does not change. Any Suggestions?

ChipR

Try changing "BILL" to [BILL].

Desitech

That worked to get my background highlighted. But because I have to change the label to a txtbox, in order to conditianally format it, the label text is gone. How can I gat the label text to come back?

ChipR

You can set the control source of the text box (in properties or by typing into the box) to

Expand|Select|Wrap|Line Numbers

= "Label Text"

You do need to type in the equals sign.

Desitech

Great....That did it. Thanks for all your help.

ADezii

Quote:

Originally Posted by Desitech

I have a Label on a report with a check box from a table indicating True or False. I would like to have the labels that are true to highlight yellow using conditional foramtting. The False labels to remain unhighlighted. I have tried changing the label to a text box and then conditional formatting "Expresion Is" "BILL"=TRUE. But the formatting is not working. I loose my Label text and BackColor does not change. Any Suggestions?

In the Detail Event of the Report, try something similar to:

Expand|Select|Wrap|Line Numbers

 Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If Me![<Check Box Name>] Then

  Me![<Label Name>].ForeColor = vbYellow

Else

  Me![<Label Name>].ForeColor = vbBlack

End If

End Sub

Conditional Formatting of a label on a report

re: Conditional Formatting of a label on a report

re: Conditional Formatting of a label on a report

re: Conditional Formatting of a label on a report

re: Conditional Formatting of a label on a report

re: Conditional Formatting of a label on a report

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about