Zero Suppress
in [Reports]
|
From: Peter Marshall on 31 Mar 2010 08:42 This is probably very simple: I have a report that displays many columns of numbers, many of which are zeroes. To make the report more readable, I would like to suppress the zero values so that the only #'s that display are non-zero values. How can I do this? -- Peter Marshall Manager Information Services Ohio Coatings Company
From: Marshall Barton on 31 Mar 2010 09:32 Peter Marshall wrote: >This is probably very simple: I have a report that displays many columns of >numbers, many of which are zeroes. To make the report more readable, I >would like to suppress the zero values so that the only #'s that display are >non-zero values. Use a custom format on the text boxes where you want to do that. If the numbers are Currency type the format might be something like: $#,##0.00;($#,##0.00);"" See the Format Property topic in VBA Help for all the formatting codes that can be used, Pay close attention to the four different sections for positive, negative, zero and Null values. -- Marsh MVP [MS Access]
|
Pages: 1 Prev: Wow what a help this guy is Next: Previous pages running total on the next page header |