 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / October 2004Null Fields in Reports
How do I omit a field on a report only when it is a null value? >How do I omit a field on a report only when it is a null value? What do you mean by "omit"? If the text box that displays the field is in a "horizontal band" by itself, the just set both the txt box and its section's CanShrink property to Yes. If you mean something else, please explain.  SignatureMarsh MVP [MS Access] We have a report we use often and if the fields are not filled in, we would like them to not show up. We want the report to print only the fields that have inputted data. Thank you, Cathy > >How do I omit a field on a report only when it is a null value? > [quoted text clipped - 5 lines] > > If you mean something else, please explain. Well, I got that much the first time. Did using CanShrink take care of your question? If not, you will have to expand on how the controls (not fields) appear in the report. Are they all next to each other across the page or are they one above the other down the page? Do you want them to be blank or do you want the other controls to move up/left to squeeze out the blank space? Do they have attached labels? What are their border property setting? SignatureMarsh MVP [MS Access] >We have a report we use often and if the fields are not filled in, we would >like them to not show up. We want the report to print only the fields that [quoted text clipped - 9 lines] >> >> If you mean something else, please explain. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.