var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Toggle Button
Does anyone know how to make a toggle button show the value of Yes/No in a report. Right now I have a form the is linked to a report and the user must press a toggle button but the report shows a -1. I would like it to say Yes/No. What property do I change.
Set it with an iif().
True false always returns -1 or 0.
That's more or less a compatability issue.
=iif(Toggle = -1, "True", "False")
would I type =iif(Toggle = -1, "True", "False") into the control source of the text box in the report?
if toggle is true, then true, else false
That is what I have in a text box on the report. The name of the toggle button on my form txtTog.
I am getting a #Name error in the report.
What do you think it might be?
You can't make a report based on a form.
Where does your report get it's information.
actually I have a bunch of text boxes with this type of code in them.
It just shows the value of the query on the form.
Oh ok, are you being explicit with the txtTog?
=IIf([Forms]![Term Worksheet]![txtTog].value =-1,"True","False")
Great, we got a winner.