checkbox value as numeric

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Robbie said:
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?
Click to expand...

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.
 
How are you using Abs? It definitely should change -1 to 1: that's its
purpose.
 
Douglas:

=Abs([YesNoField])

I thought so too. It works good with headers/footers but for details it
errors.
 
Thank you Rick, it worked fine.

Rick Brandt said:
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.
Click to expand...
 
Back
Top