Howto make a field not visible by event?

[Lycanthrop]

Hey!


I'm struggling to make a field not visible in a report (if it's value is 0).


Tried the following code (in Detail | Event | On Format) but no luck: =IIf([Discount]=0;([Discount].[Visible]=False);([Discount].[Visible]=True))

Nor does this simple code work: =[Discount].[Visible]=False



Any ideas?

[JoeM]

Where are you putting this? It looks like you are trying to do a calculated field. "Visible" is a property, not a field (so would not be enclosed in brackets), and you would not put this in the Control Source.

Actually, I think the easiest way to do this is with Conditional Formatting (requires no VBA). Just select the field, right click and select Conditional Formatting, and when the value is zero, select the text color to match the background color (usually white). Then it will not be visible when it is zero.

[Lycanthrop]

Many thanks JoeM, worked perfectly! I was not aware of the Conditional Formatting function


The code was put in the report under Detail | Event | On Format. The brackets appeared automatically.

Also I have a text box (under the GroupHeader0) that needs to be invisible when all the values are 0 in one particular field under Detail. Is it possible to use the Expression Builder to produce a code that changes the .visible property (or color) for this field?

[JoeM]

Note that under Conditional Formatting, there is an "Expression Is" option. So you could enter an expression like:

([Field1]=0) And ([Field2]=0) And ...

See this for more details: http://office.microsoft.com/en-us/ac...010208133.aspx

[Lycanthrop]

Thanks for the additional info JoeM!