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
|
|||
|
|||
"Can Grow" across multiple objects
I have made a Report from my data which ended up looking like a spreadsheet.
It has multiple fields side-by-side within the detail section. One of the fields is a memo field that I have set "Can Grow" to yes because some of the data can become lengthy. When the memo field grows vertically, the other fields next to this field does not grow with it and makes the Report look messy. Is there a way to make these other fields grow when the memo field grows? Thanks, Mark |
#2
|
|||
|
|||
In the OnFormat event of the detail section, set the height of the other
fields to the height of the memo field: Me!MyField.Height = Me!MemoField.Height -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "p8md" wrote in message ... I have made a Report from my data which ended up looking like a spreadsheet. It has multiple fields side-by-side within the detail section. One of the fields is a memo field that I have set "Can Grow" to yes because some of the data can become lengthy. When the memo field grows vertically, the other fields next to this field does not grow with it and makes the Report look messy. Is there a way to make these other fields grow when the memo field grows? Thanks, Mark |
#3
|
|||
|
|||
Thanks so much for your help, but you may need to "dumb it down" so I
understand. This is what I unsuccessfully attempted. It does NOT give errors, just does nothing. Right click on the Detail section and chose Properties. In the On Format line I chose Event Procedure. Right Click on the Detail Section again and chose build event. This brought up VB. Within the Detail_Format, I entered Me!ProcessInstr1.Height = Me!ProcessInstr8.Height. ProcessInstr1 is the smaller field and ProcessInstr8 is the larger memo field. Below is the Detail_Format section from my VB code... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me!ProcessInstr1.Height = Me!ProcessInstr8.Height End Sub Any further help will be much appreciated, Mark "PC Datasheet" wrote: In the OnFormat event of the detail section, set the height of the other fields to the height of the memo field: Me!MyField.Height = Me!MemoField.Height -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "p8md" wrote in message ... I have made a Report from my data which ended up looking like a spreadsheet. It has multiple fields side-by-side within the detail section. One of the fields is a memo field that I have set "Can Grow" to yes because some of the data can become lengthy. When the memo field grows vertically, the other fields next to this field does not grow with it and makes the Report look messy. Is there a way to make these other fields grow when the memo field grows? Thanks, Mark |
#4
|
|||
|
|||
p8md wrote:
I have made a Report from my data which ended up looking like a spreadsheet. It has multiple fields side-by-side within the detail section. One of the fields is a memo field that I have set "Can Grow" to yes because some of the data can become lengthy. When the memo field grows vertically, the other fields next to this field does not grow with it and makes the Report look messy. Is there a way to make these other fields grow when the memo field grows? This is a tricky situation. Your controls have no need to grow so their border stays where it was. Actually, you don't want the control to grow, you only want the lines around the control to be even. Since that won't happen automatically, you need to set the border style for all of them to transparent and draw the lines yourself using the Line method. Since the memo field's (and the detail section's) final height is not known at the time of the Format event, you have to do this in the Print event. If you want to use a ready made code solution for this, use the PrintLines file at www.lebans.com -- Marsh MVP [MS Access] |
#5
|
|||
|
|||
Don't even try this solution since it is bound to fail. Marsh has provided
the recommended solution. -- Duane Hookom MS Access MVP "p8md" wrote in message ... Thanks so much for your help, but you may need to "dumb it down" so I understand. This is what I unsuccessfully attempted. It does NOT give errors, just does nothing. Right click on the Detail section and chose Properties. In the On Format line I chose Event Procedure. Right Click on the Detail Section again and chose build event. This brought up VB. Within the Detail_Format, I entered Me!ProcessInstr1.Height = Me!ProcessInstr8.Height. ProcessInstr1 is the smaller field and ProcessInstr8 is the larger memo field. Below is the Detail_Format section from my VB code... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me!ProcessInstr1.Height = Me!ProcessInstr8.Height End Sub Any further help will be much appreciated, Mark "PC Datasheet" wrote: In the OnFormat event of the detail section, set the height of the other fields to the height of the memo field: Me!MyField.Height = Me!MemoField.Height -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "p8md" wrote in message ... I have made a Report from my data which ended up looking like a spreadsheet. It has multiple fields side-by-side within the detail section. One of the fields is a memo field that I have set "Can Grow" to yes because some of the data can become lengthy. When the memo field grows vertically, the other fields next to this field does not grow with it and makes the Report look messy. Is there a way to make these other fields grow when the memo field grows? Thanks, Mark |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Word Document Objects in 1 project? Is it possible? | Adam Steiner | General Discussion | 7 | June 30th, 2004 02:39 AM |
resizing group of objects not working | Mike | Visio | 1 | May 19th, 2004 10:13 PM |
Multiple Many-To-Many Tables | Tom | Database Design | 7 | May 15th, 2004 03:47 AM |
Multiple values in a single cell, and validation | Harlan Grove | Worksheet Functions | 1 | December 5th, 2003 07:58 PM |