Unanswered: Check box to make text box turn grey on report.
I have a check box on a form next to 4 fields of addresses (line one, line two, line 3, line 4). When the check box is checked I want the 4 fields of address on a report to turn light grey in their boxes.
Ive done it so they turn grey on the form, but need it on the report aswell so it can be printed out.
In the detail section of the report put the next code and make the suitable changes
Note that Detailbereich = your Detail section
Private Sub Detailbereich_Format(Cancel As Integer, FormatCount As Integer)
If Forms("yourFormName").yourCheckbuttName.Value = True Then
Detailbereich.BackColor = 8453888 'yellow 8454143 'Gray 12632256
Detailbereich.BackColor = 16777215