checkbox value as numeric

[Guest]

On the report's detail area I inserted a text box to show the value of a
checkbox (i.e., 1 instead of Y, 0 instead of N). However, for Y I get -1 and
the ABS doesn't correct the error. What can anyone suggest?

 

[Rick Brandt]

On the report's detail area I inserted a text box to show the value
of a checkbox (i.e., 1 instead of Y, 0 instead of N). However, for Y
I get -1 and the ABS doesn't correct the error. What can anyone
suggest?

For the Format property of that TextBox enter...

;"1";"0"

With the above method you can make a Yes/No display any text you like for True
and for False. The leading semi-colon is required.

 

[Douglas J. Steele]

How are you using Abs? It definitely should change -1 to 1: that's its
purpose.

 

[Guest]

Douglas:

=Abs([YesNoField])

I thought so too. It works good with headers/footers but for details it
errors.

 

[Guest]

Thank you Rick, it worked fine.

For the Format property of that TextBox enter...

;"1";"0"

With the above method you can make a Yes/No display any text you like for True
and for False. The leading semi-colon is required.