Simple problem: I have a report (based straightforwardly on a table) where the value in one column is mostly 0, sometime set, so I'd like to hide it when it's 0.
To slightly complicate matters, every second line in the report has a light grey backgroud ("zebra effect", which is handy to make things more readable in a landscape format), so I can't use the white font trick, because you see the value on grey background lines.
Also, the field should always be shown with 4 decimals, so even if I define a format such as "#", it shows all the zero values because of the 4 decimals. If I set the decimals to Auto, it works, but shows me the value without decimals... Catch 22, kind of
I've tried to put a call to a small function (which would return "" or a properly formatted value for the field of that column), but that failed miserably with a "#Type!" error. The content of the report field was "=myFunction([table field name]), the function was defined as Public in one the module of the app, taking one argument (of the type of the field name) and returning a string, but Access didn't like that. No idea why.
Anybody can tell me how to do it ? It's seems such a simple problem, and yet I can't get it to work.