Print Text depending on boolean value

R

rmsimps

New member

Local time

Yesterday, 20:43

Joined

Apr 7, 2019

Messages

6

• Apr 7, 2019

• #1

I have a report that if the value of a boolean is false it will print "Dropped", and if true will print "Attending". I had it working at one time, but will not work now.

In the caption of the label I put the following code: =IIF([Attending] = True, "Attending", "Dropped") where [Attending] is the control.

 

isladogs

MVP / VIP

Local time

Today, 04:43

Joined

Jan 14, 2017

Messages

18,949

• Apr 7, 2019

• #2

When you say it doesn't work it would help to say what does happen

Anyway, you need to use the field name in your expression - not the control name

 

D

Deleted member 147267

Guest

• Apr 7, 2019

• #3

You can put an expression directly into the label caption property and it will evaluate??

 

R

rmsimps

New member

Local time

Yesterday, 20:43

Joined

Apr 7, 2019

Messages

6

• Apr 7, 2019

• #4

I solved my own problem with help from isladogs and Micron. Thank you. You jogged something in my brain.

I was placing my code into the wrong spot. I created a unbound text box and put the text in the control source. It works great.