Making -1 display as X

J

Joel

I have a query that counts checkboxes and it shows the min (ie -1, or 0).
I need all the -1's to display as "X".
Is there anyway to do this?

Thanks
 
J

John Vinson

I have a query that counts checkboxes and it shows the min (ie -1, or 0).
I need all the -1's to display as "X".
Is there anyway to do this?

Thanks
Click to expand...

One sneaky way is to use the "four value format" property of a
textbox. You can set the Format of a textbox to a string of four
formats separated by semicolons; these provide different formats for
positive, negative, zero and NULL values respectively. Since a yes/no
field only has values 0 and -1 only two of these are relevant:

"";"X";"";""

will display X for -1, and nothing for any other value.

John W. Vinson[MVP]
 
Top