If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Showing Only Labels in the First Column of a Report
I've used the instructions in article Q208491 to set up a multi-column report
with lables in only the first column. I created disassociated labels and text boxes, placed the labels directly over the text boxes and made the textboxes, labels and report width all 1.5". Then I wrote code in the OnFormat of the detail section: If Me.Left (1.5 * 1440) Then Me![lbl1].Visible = True Me![lbl2].Visible = True Me![lbl3].Visible = True Me![txt1].Visible = False Me![txt2].Visible = False Me![txt3].Visible = False Else Me![lbl1].Visible = False Me![lbl2].Visible = False Me![lbl3].Visible = False Me![txt1].Visible = True Me![txt2].Visible = True Me![txt3].Visible = True EndIf I set the # columns to 5, which fit nicely on my report. The problem is that the labels are covering up data. I am trying to show Jan. - Aug. data on the report and the 1st page shows Feb. Mar. Apr. May and the 2nd page shows July & Aug. It's almost like the labels are covering up the first colum of data on each page, Jan. & June. Seems to defeat the purpose, so I must be doing something wrong. Any ideas? Thank you. |
#2
|
|||
|
|||
Alex wrote:
I've used the instructions in article Q208491 to set up a multi-column report with lables in only the first column. I created disassociated labels and text boxes, placed the labels directly over the text boxes and made the textboxes, labels and report width all 1.5". Then I wrote code in the OnFormat of the detail section: If Me.Left (1.5 * 1440) Then Me![lbl1].Visible = True Me![lbl2].Visible = True Me![lbl3].Visible = True Me![txt1].Visible = False Me![txt2].Visible = False Me![txt3].Visible = False Else Me![lbl1].Visible = False Me![lbl2].Visible = False Me![lbl3].Visible = False Me![txt1].Visible = True Me![txt2].Visible = True Me![txt3].Visible = True EndIf I set the # columns to 5, which fit nicely on my report. The problem is that the labels are covering up data. I am trying to show Jan. - Aug. data on the report and the 1st page shows Feb. Mar. Apr. May and the 2nd page shows July & Aug. It's almost like the labels are covering up the first colum of data on each page, Jan. & June. Seems to defeat the purpose, so I must be doing something wrong. Since you've made the text boxes invisible when the data is in the left most column, they won't be displayed. What you need to do is process the first column's data records a second time to get them to display in the second column. This is very easy to do by adding: Me.NextRecord = False to the true block of the If statement. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Perfect! Thank you -
"Marshall Barton" wrote: Alex wrote: I've used the instructions in article Q208491 to set up a multi-column report with lables in only the first column. I created disassociated labels and text boxes, placed the labels directly over the text boxes and made the textboxes, labels and report width all 1.5". Then I wrote code in the OnFormat of the detail section: If Me.Left (1.5 * 1440) Then Me![lbl1].Visible = True Me![lbl2].Visible = True Me![lbl3].Visible = True Me![txt1].Visible = False Me![txt2].Visible = False Me![txt3].Visible = False Else Me![lbl1].Visible = False Me![lbl2].Visible = False Me![lbl3].Visible = False Me![txt1].Visible = True Me![txt2].Visible = True Me![txt3].Visible = True EndIf I set the # columns to 5, which fit nicely on my report. The problem is that the labels are covering up data. I am trying to show Jan. - Aug. data on the report and the 1st page shows Feb. Mar. Apr. May and the 2nd page shows July & Aug. It's almost like the labels are covering up the first colum of data on each page, Jan. & June. Seems to defeat the purpose, so I must be doing something wrong. Since you've made the text boxes invisible when the data is in the left most column, they won't be displayed. What you need to do is process the first column's data records a second time to get them to display in the second column. This is very easy to do by adding: Me.NextRecord = False to the true block of the If statement. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Column Chart labels on all columns | Mark | Charts and Charting | 1 | May 26th, 2005 07:42 PM |
How do I Change column labels to ABC from 123 ? | Jeff | Worksheet Functions | 1 | May 14th, 2005 02:13 PM |
How to group similar column titles together???? | vrk1 | General Discussion | 2 | April 30th, 2005 12:17 AM |
Printing Multiple Labels based upon the amount in a column | MarySC | Setting Up & Running Reports | 4 | April 3rd, 2005 05:17 PM |
Hyperlinking rows labels with column labels between 2 sheets in same workbook | Daniel | Worksheet Functions | 3 | June 25th, 2004 09:22 AM |