Topics Search

Report detail and line spacing capabilities

Report detail and line spacing capabilities
Views: 22
I have created a report and I'm trying to have as little space as possible between each row of data. I've reduced the font and height of my boxes to 0.1 (think this is the limit) and pushed up the margin.

This seems to be the best I can do. It's close together but I was wondering if I could get it closer. This may be all that Access will allow me to do. Am I right? If so,I can deal with it but just wanted to know if there was anything else I could do.
Sponsored Links:

Similar posts...


line spacing in access 2010

line spacing in access 2010 Icon
I know this is crazy, but I can't find anything in "access reports 2010" which allows me to adjust the line spacing. Seems like a "no brainer" but I can't find anything. The default spacing is "huge", yet line spacing is set at 0cm.

Quick note: line spacing is the distance between detail lines.

Draw line in report detail

Draw line in report detail Icon
I'm trying to draw a line in the detail section of the report using VBA. Can anyone give me some guidance? I've found some help pages from microsoft, but can't get it working.

I'm using Access 2007.

I have:

Me.ScaleMode = 7
Me.Line (1, 1)-(2, 2), RGB(0, 0, 0)

In the OnPrint event of detail. I've also tried the OnPage event of the report and the OnFormat event of the detail

Line Spacing

Line Spacing Icon
I have a report that has two lines for a description. The report provides an additional line for the second line of the description in the record. Sometimes, however I only need to use one line, and not the second one. How can I get the report to not provide for the second description line if this field is blank?

Group Header is on same line as detail?

Group Header is on same line as detail? Icon
I'm trying to create a report in the format at the bottom of this post.

I've changed the number of columns to 4 and have a new row for each group.

The new row was an attempt to get the rank at least on the left of the report, else it could be the 3rd entry in the detail line after the last detail data.?
However a side effect of multiple columns is that is that the group header appears as the first entry in the detail line, so the report looks like

Rank Name Name Name

How can I achieve the desired layout please?

Desired layout

Rank (Group Header)

Name Name Name Name
Name Name Name Name
Name Name Name Name


Name Name Name Name
Name Name Name Name
Name Name Name Name

Rounding Issues on report display

Rounding Issues on report display Icon
I have an Access report with several lines of detail with a dollar amount amount calculated by multiplication of salary amounts times certain percentages. This is giving me results of 3-4 decimal places. On the detail line - I formated the amount to currency, and use 2 decimals - and each line is displaying correctly and is rounded correctly. However, I have breaks with summing subtotals in the report - and they are showing a total that is slightly off because it is summing the amount from the detail lines without the 2 decimal place rounding - so a lot of times it is a penny or two off. I have the subtotal amount formatted the same as the detail line - so it displays in a 2 decimal format - but the total is sometimes wrong. Any ideas on how to get my subtotals to correctly add up the rounded amount, and not the unformated/unrounded amount?

how to keep information in footer section in same place on pre-printed form

how to keep information in footer section in same place on pre-printed form Icon
How do I keep the information in the footer section of a access report from expanding when the detail section changes?

The information in the detail section is description for an invoice. It could be 1 or many lines. In the report footer section are the totals for the detail section, sales tax, sub total, invoice total.

it prints ok when we have just one line in the detail section, but when more then one line, it moves the footer section down

Reports in column format

Reports in column format Icon
My report page set-up is for 3 columns with zero spacing between columns. There is a box around the set of controls. I have the palette narrowed to the absolute minimum width so that there is no working space to the right of my controls. The result is a calendar-like presentation. The problem arises when I want to center text in the headers and footers. If I simply place my header text in the header section, it will appear more or less towards the left side of the page. In order to get it centered, I have to widen the palette and then center the text manually. If I do this, then the spacing between columns in the detail section increases - even though the column spacing is set to zero. I think that the solution is finding a way to keep the columns together.

Create Alternating Row Colors on a Report

Create Alternating Row Colors on a Report Icon
By default, Access formats each row of a report's detail section with the same background color. When printing a report, shading every other line of the detail section can make it much easier to read. Learn how to apply shading to every other row in a report.

Using VBA to hide a report's detail section?

Using VBA to hide a report's detail section? Icon
I am using Access 2007. I have created a report with a detail section and some summary information in the group header. Sometimes I want to see the detail section, but other times I would like the detail section to be hidden so that I only get the summary info. Can anyone tell me if there is a relatively easy way I can give myself this choice each time I run the report using VBA? If so, if you could give me a quick sample of how to reference a report's detail section and tell me what is the best event to use if I want to set the .Visible property to False,

Or is it easiest to just create two reports, one with the Detail section visible and one with the detail section not visible?

Memo field expansion in details section of report?

Memo field expansion in details section of report? Icon
I have a Access 2003 report. I have added a memo field to the details section. I have carriage returns in the field and some of the records returned have memo fields with anywheres from 1 to 15 carriage returns.

I would like to dynamically expand the vertical size of the details section to only show the required space to show all 15 lines in the memo field, so that if I had 3 detail lines as so:

detail line 1,: memo field has 15 carriage returns
detail line 2: has 1 carriage return

the detail section will really only be approximately 16 lines in height not 30.