Sabtu, 24 September 2016

Re: [MS_AccessPros] Report: Detail Height problem.



You have some control at the very bottom of the section that's keeping you from shrinking it.  In Design view, place your mouse on the ruler on the left side near the top of the section.  You should see your mouse pointer becoming a right-pointing arrow.  Click and drag down into the bar that's the header for the next section, then let go.  That should select all (or nearly all) the controls in the section, including any at the bottom of the section.  I would bet you have a line control or some other hard-to-spot control right on the bottom edge.  Try to select just that and move it up.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)

On Sep 24, 2016, at 2:27 AM, Robin Chapple [MS_Access_Professionals] <> wrote:

Thanks John,

I do have the controls at the top edge 0f the section. I cannot make the detail height equal to the text boxes in the section. I have tried the "Reductio ad absurdum" idea by making the text boxes very small. The detail does reduce but the printed output is still showing more white space than the line of text. In this case 3mm of text and 5mm of space.



At 24/09/2016 01:01 AM, you wrote:


You cannot reduce the height of a section smaller than the "tallest" control in the section.  Sounds like you first need to reduce the Height of your controls, then you can reduce the size of the section.  Or, if your controls are already not too high, you need to move them to the top edge of the section because you can reduce the height of a section only from the bottom.

John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications

On Sep 23, 2016, at 03:13, Robin Chapple [MS_Access_Professionals] <> wrote:

I am using Access 2013. I have a report that leaves too much white 
space between the lines of text. I cannot reduce the detail height 
below 0.492 cm.
What can I do to gain the space?
I am using Arial Narrow as the font.


Robin Chapple

Posted by: Robin Chapple < >


Yahoo Groups Links

<*> To visit your group on the web, go to:

<*> Your email settings:
   Individual Email | Traditional

<*> To change settings online go to:
   (Yahoo! ID required)

<*> To change settings via email:

<*> To unsubscribe from this group, send an email to:

<*> Your use of Yahoo Groups is subject to:


Posted by: John Viescas <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.



Tidak ada komentar:

Posting Komentar