Showing Text When a Checkbox Is Checked

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I have a report and form, on the form is a checkbox (called fip).
When i run the report, i want a text box on it to display the letter X if the
checkbox is checked. how do i do this? (sorry i'm new to access)
 
In the control source of the field in the report you can write

=IIf(Forms![FormName]![fip] = True, "X","")
 
Tried this but all i'm getting when i run the repot is #Error
the text box (called priority) on the report (called fintl) has this as it's
control source:
=IIf(Forms!fintl!priority=True,"X","")

Any further hints are much appreciated

Ofer said:
In the control source of the field in the report you can write

=IIf(Forms![FormName]![fip] = True, "X","")

--
\\// Live Long and Prosper \\//
BS"D


aft3rgl0w said:
Hello, I have a report and form, on the form is a checkbox (called fip).
When i run the report, i want a text box on it to display the letter X if the
checkbox is checked. how do i do this? (sorry i'm new to access)
Click to expand...
Click to expand...
 
Is fintl that name of the report or the form, it need to be the name of the
form

=IIf(Forms![FormName]![CheckBoxNameInTheForm]=True,"X","")



--
\\// Live Long and Prosper \\//
BS"D


aft3rgl0w said:
Tried this but all i'm getting when i run the repot is #Error
the text box (called priority) on the report (called fintl) has this as it's
control source:
=IIf(Forms!fintl!priority=True,"X","")

Any further hints are much appreciated

Ofer said:
In the control source of the field in the report you can write

=IIf(Forms![FormName]![fip] = True, "X","")

--
\\// Live Long and Prosper \\//
BS"D


aft3rgl0w said:
Hello, I have a report and form, on the form is a checkbox (called fip).
When i run the report, i want a text box on it to display the letter X if the
checkbox is checked. how do i do this? (sorry i'm new to access)
Click to expand...
Click to expand...
Click to expand...
 
Back
Top