Unanswered: HELP!! Checkbox needed to Grey out Text box in a report
I need help quick!
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.
My form name is - sentence_history_new
The checkbox in the form is called NFA
The address box on the report (and form) is - address_1
The code I entered is -
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Forms("sentence_history_new").NFA.Value = True Then
Address_1.BackColor = 12632256
Address_1.BackColor = 16777215
The above code was from a previous post, but it wont work. Any ideas why its not working?
Just put that code in to the reports event procedure and nothing is happening, no errors, nothing. Ive got on record checked, and the other unchecked and the text box isnt changing color when checked :s