Hiding a value - True / False

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

In Access 2000 (Frontend) Sql server (backend) - I have a view that I
created which is the control source for a report. I have fields that
provide True or False as data. It has been requested that only the True
values show on the report. In the criteria, i had placed for example
"Shrink Wrap" = 0, "Jacketing" = 0. The problem is that all the Shrink Wrap
= True appear, but none of the others. Please see below for a better
example.


Job ShrinkWrap Jacketing Inserts
1234 True False True
4567 False True True

I am looking for the True values to remain on the report, but the Flase
values to be blank with no data. Hope this isn't to confusing.
 
If you just want to fudge it (if you need to get this out fast), you can use conditional formatting and set it so that if value = "False" then the font color is white (or whatever your background is).

It sounds like you need an if then something like this...IIf ([Shrinkwrap] = "True", "True") - if you leave the "else" part of the "if, then, else" statement blank then you should get a null value (blank)

Hope this helps

Daw
 
You can set the format property so that the value displayed is different
based on whether the control source evaluates to: Positive, Negative, Zero,
or Null. Check Help on Format Property - Numeric.

This solution depends on if your values are boolean or are they actually
text/string values. Boolean True values return -1 or +1 while False returns
0.
 
Back
Top