Topics Search

Report detail and line spacing capabilities

Report detail and line spacing capabilities
Views: 18
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:

More topics

 

line spacing in access 2010

Preview
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.
 

line spacing in access 2010

Preview
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

Preview
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

Preview
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?
 

Hide Duplicates

Preview
I have a report in Access 2003 that creates a report as follows:
Line # detail 1 detail 2 detail 3
1 Joe Frank Steve
2 Blank Blank Jake
3 blank Sam Larry
4 Arnold blank Sarah
5 blank Peter Ruth
6 blank Ralph Joe
7 blank blank Snoopy
I'm expecting to see Sam in detail 2 line 4. I'm trying to rid myself of duplicates of detail 2 resetting on a new detail 1 and duplicates of detail 3 resetting on a change of detail 3. Lines 5 - 7 work as expected. I'm using Hide Duplicates on the text fields for detail 1 and detial 2, but when detail detail 2 is the same in the previous line as the current line then detail 2 doesn't blank out correctly.

I'm expecting to see..
Line # detail 1 detail 2 detail 3
1 Joe Frank Steve
2 blank blank Jake
3 blank Sam Larry
4 Arnold Sam Sarah
5 blank Peter Ruth
6 blank Ralph Joe
7 blank blank Snoopy
Does anyone have suggestions?
 

Group Header is on same line as detail?

Preview
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

Rank

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

Rounding Issues on report display

Preview
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

Preview
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

Preview
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

Preview
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.