Hiding a value - True / False

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.
 
D

Dawn

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
 
D

Duane Hookom

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.
 
Top