15 pts.
 How to shrink report detail
I have a report upon a simple table, fields nm,a, b,c The report would print these fields under (one field=one line) nm -already a when condition fits b when condition fits c -already I know, I can set visibility : Private Sub Detail_Format... if cond.... Me![a].Visible = False Me![b].Visible = False That's OK, these fields are not visible, but their empty lines remain in report. So, what I need, is shrink these empty lines, to get a shorter report section. To get more record in one page, for example. Is any way how to do it???

Software/Hardware used:
ASKED: August 10, 2009  12:55 PM
UPDATED: August 14, 2009  8:06 AM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Hi there,

Welcome to IT Knowledge Exchange. Can you please specify what reporting program you’re using?

Thanks,
Jenny
Community Manager

 4,265 pts.

 

Sorry, I mean the MS Access 2003 application.

 15 pts.