Check box to text.

  • Thread starter Thread starter eschlep via AccessMonster.com
  • Start date Start date
E

eschlep via AccessMonster.com

I have a report that is updated by a form. How would i put a check box on a
form and then instead of have a check box on the report have different text
display on the report based on if the check box is checked or not.
Thanks
 
Set the checkbox as Visible = No

Add new text box and use this is it's control source

IIf ([CheckBox]=-1, "SomeText","SomeOtherText")
 
I can not get this to work. I change IIf to just if and CheckBox to the name
of my checkbox and it still doesnt work


Wayne-I-M said:
Set the checkbox as Visible = No

Add new text box and use this is it's control source

IIf ([CheckBox]=-1, "SomeText","SomeOtherText")
I have a report that is updated by a form. How would i put a check box on a
form and then instead of have a check box on the report have different text
display on the report based on if the check box is checked or not.
Thanks
Click to expand...
Click to expand...
 
I would also like to have two check boxes linked together on the form and on
the report i would like to display yes if if one box is checked and no if the
other is checked. If there is an easier way to do this that would work too.
THanks
 
=IIf ([CheckBox]=-1, "SomeText","SomeOtherText")

Copy it exactly into the control source "then" change the [CheckBox] for the
name that you use on your report. But leave the [ ] in place (put the name
between them with no spaces)

To "link" 2 check boxes simply refer to the 1st from the 2nd control source.

Set this as your control source form the 2nd check box. To give you a Tick
if the other is not ticked use this

=IIf ([CheckBox]=-1, 0,-1)

Again copy it exactly then alter the [CheckBox] name - in this case to
whatever you call the 1st Box

IMORTANT
Don't forget that you should use the Name of the check boxes NOT the
Caption.

Tip.
You can find the "Name" at the top of the "Other" column on the properties
box.

--

Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.
 
Rather than "Linking" 2 check boxes why not simply use a toggle group. Use
the wizard to make it for you if you're not sure how to do this.

Hope this helps
 
Back
Top