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

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?
 

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.
 

Report Detail Not Displaying As Needed

Report Detail Not Displaying As Needed Icon
I am creating a report and am totally stuck on details not displaying how I would like. I cannot seem to figure this out, I would like the report to display "days" each customer account has been serviced - by month.

I've created queries to pull the "day" from each date serviced, and by month. I do have the days showing in the appropriate month column on the report, but I need for them to all start at the top of the detail line. Kinda hard to explain. But essentially my report is looking like this:
 

detail.height not to shrink after accommodate a large text box

detail.height not to shrink after accommodate a large text box Icon
Have set detail.height in OnOpen event of report. Have set Detail to can grow/can shrink. Have set text boxes in Detail section to can grow/can shrink. Have set detail.height in OnFormat event of detail section.

However, after the first time the detail section needs to grow (which it does OK) it does not shrink back for other records displayed in Detail section. LIne height is changing as it should,but not Detail section height.
 

Header must grow same amount as detail

Header must grow same amount as detail Icon
I know this may seem odd, but honestly, this is what I need to make the layout proper.

I have GroupHeader1. It Can Grow.
I have GroupHeader2. It Can Grow.
I have Detail. It Can Grow.

The layout results in:
GroupHeader1 | GroupHeader2 | Detail Item1
Detail Item2
Detail Item3
GroupHeader2 | Detail Item1
Detail Item2
GroupHeader1 | GroupHeader2 Detail Item1

The report requires a horizontal row at each Detail Item.

Detail Items may vary in height.
GroupHeader1 Items may vary in height.
GroupHeader2 items may vary in height.

Here's the tricky part: At all times the height of GroupHeader1, GroupHeader2 and Detail Item MUST be the same WHICH EVER IS THE GREATEST AMOUNT.

Otherwise what happens in the horizontal line of Detail may cross through the verbiage of GroupHeader1 or Groupheader2.

The width of the textboxes cannot be adjusted further.
 

Replacing one line of data with multiple lines

Replacing one line of data with multiple lines Icon
I have a table, called Data1. Within this table exist raw paroll data but the data is consolidated by certain segments.

I have a 2nd table, called Payroll Detail. Within this table exist the detail payroll data by employee by segment that totals line consolidated line by segment in Data1.

I'm trying to create a query or something that allows me to combine the two sets of information. I need to include some data that is in Data1 and not in Payroll Detail table. However, instead of my results showing the consolidated line by segment, I want it to match up some criteria and give me the detail by employee by segment from Payroll Detail table.

So in otherwords, I want it to replace one line from one table with several lines from the 2nd table.