By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,096 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Hide Value 0 in Report

P: 1
I created a Report in Access which shows the incoming and outgoing material
to Vendor. But when we received same quantity as we given to vendor balance will show 0. So, I want to Hide those entry which shows a 0 balance
Oct 8 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
Assuming Access 2000 or later, if you simply want a blank space rather than the zero, have a look at Conditional Formatting for the field.

Field Value
and Is Equal to and 0

then change the fore color to white and the zero won't show.

It you have something esle in mind, you'll need to give us a little more explanation.

Welcome to TheScripts!

Linq ;0)>
Oct 8 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.