Showing Text When a Checkbox Is Checked


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)
 
Ad

Advertisements

G

Guest

In the control source of the field in the report you can write

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

Guest

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)
 
Ad

Advertisements

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top