Report issues with Yes/No in a string

[TrishaL]

Hi
In my report I have this:
=("Availability Water Sourcing: " & [AvailabilityWaterSourcing])
This field is a yes/no field. I think I have all of my settings right for yes/no field, etc. When it is in the string it shows as "0" or "-1". When I take it out of the string it works properly and shows yes or no in my report. I want it in the string as it makes it look nicer when I print as I have a number of fields.

If anyone could help me with this I would appreciate it. Thank you

 

[Micron]

AFAIK, all you need to do is format the control (in design view) as yes/no.

When it is in the string it shows as "0" or "-1". When I take it out of the string it works properly and shows yes or no in my report.

I don't understand that. A string can only be text. Maybe you mean 'when it(?) is in the expression'. I take it that the control with that expression is not bound to anything.

 

[TrishaL]

AFAIK, all you need to do is format the control (in design view) as yes/no.

I don't understand that. A string can only be text. Maybe you mean 'when it(?) is in the expression'. I take it that the control with that expression is not bound to anything.

Hi, I have this entered in a text box: =("Availability Water Sourcing: " & [AvailabilityWaterSourcing])
The field "AvailabilityWaterSourcing" is a yes/no text field in my query. When I put it into the string shown above it shows as -1 and 0. Is there a way to show as a Yes/No?

 

[Norie]

Try replacing [AvailabilityWaterSourcing] with this formula.

 Iif([AvailabilityWaterSourcing], "Yes", "No")

 

[TrishaL]

Try replacing [AvailabilityWaterSourcing] with this formula.

Iif([AvailabilityWaterSourcing], "Yes", "No")

Yes of course. This works perfectly. Thank you so very much!!

 

[Micron]

Well, you didn't say whether or not you formatted the control to yes/no so I guess we'll never know if that would have worked for you.
With that solution, if there is no value in the field it is neither true or false, it is null, so then what?