If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I Eliminate Blank Fields in a Report?
in an access report, when a field has no data in it, how do you "slide the
fields up"? For instance, if an address has the company, name, address, city, state, zip for fields, and the contact has no "company", how do you keep the printout from looking like this: John Doe 1220 Lone Lane Ft. Wayne, IN 46835 |
#2
|
|||
|
|||
You can make each control zero-height. In other words, squeeze them
vertically so they turn from a box to a line. eliminate all the space between them (squeeze them together). Now set each of them to "can grow = true" in their properties. You can do the opposite and leave them like they are, then set the "can shrink" to true. Make sure to set your detail section to "can shrink" as well. Rick B "Dawnie" wrote in message ... in an access report, when a field has no data in it, how do you "slide the fields up"? For instance, if an address has the company, name, address, city, state, zip for fields, and the contact has no "company", how do you keep the printout from looking like this: John Doe 1220 Lone Lane Ft. Wayne, IN 46835 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multi-column report with text from separate fields flowing down each column | Rabi Tripathi | Setting Up & Running Reports | 3 | September 30th, 2004 03:23 AM |
Blank Form Fields | Eli | Using Forms | 3 | June 1st, 2004 12:46 AM |