1. Right-click on the field and select Format
2. Select the Common tab
3. Click the formula button next to Suppress. The Formula Editor will display
4. Drag the database field from the data explorer onto the Editor
5. Add the condition = 0
6. Cick Save and Close
>How do I set a field on a report to appear blank if the numeric value it contains for a record is zero? ... like the Fox report field setting of the same concept?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer