|
| 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
November 27th, 2005, 05:25 AM
posted to microsoft.public.access.reports
|
|||
|
|||
Show if
Good day friends,
I have a very simply database with records that will most likely have a couple fields empty (sub-categories). I need to print a report without wasting space on empty fields.. Is there a "Show if" kind of command in Access Reports?? (I am an ASP programmer and usually create all reports for web display!!) Any other suggestions that does'nt require splitting the database tables are welcomed ;-) Thank you. Einy 
|
|
#2
November 27th, 2005, 06:39 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Show if
Use the CanShrink and CanGrow properties of the controls on your report.
Be sure to check these properties for the (Detail?) section as well. Providing there is nothing else overlapping these controls vertically, they will then shrink (or grow) vertically according to the amount of space required. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Einy" wrote in message ... Good day friends, I have a very simply database with records that will most likely have a couple fields empty (sub-categories). I need to print a report without wasting space on empty fields.. Is there a "Show if" kind of command in Access Reports?? (I am an ASP programmer and usually create all reports for web display!!) Any other suggestions that does'nt require splitting the database tables are welcomed ;-) Thank you. Einy
|
|
#3
November 27th, 2005, 07:01 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Show if
Thanks Allen...
Very simple and very effective indeed... I had to re arrange some fields on the report layout but was really very effective... Thanks again. "Allen Browne" wrote: Use the CanShrink and CanGrow properties of the controls on your report. Be sure to check these properties for the (Detail?) section as well. Providing there is nothing else overlapping these controls vertically, they will then shrink (or grow) vertically according to the amount of space required. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Einy" wrote in message ... Good day friends, I have a very simply database with records that will most likely have a couple fields empty (sub-categories). I need to print a report without wasting space on empty fields.. Is there a "Show if" kind of command in Access Reports?? (I am an ASP programmer and usually create all reports for web display!!) Any other suggestions that does'nt require splitting the database tables are welcomed ;-) Thank you. Einy
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| e-mail slide show | Leo | Powerpoint | 1 | March 20th, 2005 10:49 PM |
| ending the slide show | Pastor | Powerpoint | 2 | January 10th, 2005 09:20 PM |
| Slide Show Presentation | I NEED HELP WITH MY PRESENTATION!!! | Powerpoint | 5 | December 28th, 2004 04:34 PM |
| Adding a message to a running show | Dan Gramza | Powerpoint | 20 | December 17th, 2004 04:35 AM |
| Projector Speeds up Show | JayBird | Powerpoint | 1 | May 27th, 2004 09:44 PM |
Linear Mode
