horizontal line at bottom of the detail

Can I ask regarding to how to place a horizontal line at the bottom of the detail?
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.

Sponsored Links:

Related Topics

Header must grow same amount as detail
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.


Group Header is on same line as detail?
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


Hide Duplicates
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?


Drawing horizontal lines in Detail Area (Access 2003 xp sp3)
I have a report that we will use as a job card with a fixed header and footer size and a sub header of variable size. (Can grow to fit multiple items on the to-do list) What I want to do is generate horizontal lines for writing on 1cm apart in the detail section. How can the size of the detail section be calculated.

I have in mind to create Do / Until loop that generates the lines at 1cm spaces until it runs out of space. I just don't know how to determine the size of the detail space per page.

Thought - A standard page will be a set height. Can I call the height of each header and footer, subtract it from the total height and then set the detail height to the result and then use that result as the max height in my Do/Until loop?


Draw line in report detail
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


Form in design view looks perfect but not in form view
I'm designing a relatively simple form, however I seem to be having a problem with the size of my detail section. In design view the form looks exactly the way I want it to appear, but when I switch to form view the last line of text boxes in the detail section vanishes. I've tried resizing the detail section but I don't seem to be able to lower the bottom edge of the detail section to make the text boxes visible.

I've turned on the lines to show where the sections are bounded in forms view, but they never change position no matter what I do in design view...


Replacing one line of data with multiple lines
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.


Control of horizontal scroll bar
I am working on a searchable form (left side is for entering criteria and right side is for displaying records matching criteria). The width of the form currently exceeds my screen so I see a horizontal scrollbar on the bottom. I would like to add a command button that when clicked will cause the scrollbar to move to the right. Can anyone assist


detail.height not to shrink after accommodate a large text box
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.


how to keep information in footer section in same place on pre-printed form
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


Rounding Issues on report display
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?


Can Grow Property
In a report, I insert horizontal and vertical lines. When I set the property “Can Grow” to Yes, and the entry wraps around and makes the record wider vertically, the vertical lines in that particular record no longer touch the horizontal line below it. Can this be fixed?


Datasheet view change
Is there a way to set the data entry line on a datasheet view (in a subform) to be the first top line or does it always have to be the last bottom line?

MS Access 2007, Windows 7


generate multi-level csv
I need to generate a CSV file structure like below with MS Access. I assume multi-level would be a good term for this type of structure. Anyway, no clue as to how I create this for say hundreds of records daily. What is this called and where do I start?

(. periods represent indents for each line)
Message Header Record1
.Message Detail Record1
.Package Detail Record1
.Message Detail Record2
.Package Detail Record2
.Package Detail Record3
.Message Detail Record3 (cancel


Memo field expansion in details section of report?
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.


String formatting question
I have latitude and longitude for county borders for over 500 counties. For each county I have anywhere from a few hundred to thousands of coordinates, I have a need to have all the coordinates in a(horizontal)line in this format:
Lat(space)Long,(space)Lat(space)Long, and so on. I must stress that I am looking for the lat/long to be in horizontal. I guess that means no carriage return. not sure if that is the appropriate term.
I have the list of coordinates in access. I tried to export to word and manually do this but this will take forever.


Subform moving line and label
I have created a subform based on a query. The subform is surrounded by lines but depending if the subform is populated at all or not the bottom line, below the subform, will move up or down.

I also have a label 'set to front' that is behind the subform which has the same movement as the line. I was wondering how I can permanently place the line and label no matter if the subform has any values in it or not.


Forcing Page-Break from sub-form
Im printing to a Pre-Printed Invoice that has only 22 detail lines items available but I have 28 line items to print. I need to print the main Invoice form information again and continue with the remaining 6 line items.

A secondary issue is; the main form has a running sum for the sub-form detail line items. Can the running sum total be suppressed on the first page when a second page is needed


What determines the record sort order.
I have a 2003 Access database. I have an "Invoice" form where users create an invoice. It have header and detail records. I have created append queries that will turn an Invoice into a new quote. The resulting detail in the new quote needs to be in the same physical order it is in the Invoice. The detail lines are sorted by a line ID " Autonumber" that is created when they add lines to the invoice. When I run the append query for the detail lines it doesn't create new line ID's in the same order they were in from the invoice. I guess I am saying when you do an append query to a table with a autonumber, does the sorting in the query still determine the sort outcome of the order.


Specifying Graph Location in Access Report
I've built an Access Report which shows how many times I delivered something late to my clients. In the report I have the following sections: Page Header, Client Header, Detail and Page Footer.

I’d like to put in a simple pie-graph specifically at the bottom of the last page of the Detail Section per client. This may be a single page per client or it could be multiple pages by client.

I’m pretty confident that I can use the Wizard to insert the graph [even though I’ve never tried this before], but I don’t know how to limit the graph to show just once, nor do I know how to say always show at the bottom of the section.