A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Can Grow" across multiple objects



 
 
Thread Tools Display Modes
  #1  
Old December 20th, 2004, 03:31 PM
p8md
external usenet poster
 
Posts: n/a
Default "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  
Old December 20th, 2004, 05:07 PM
PC Datasheet
external usenet poster
 
Posts: n/a
Default

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  
Old December 20th, 2004, 09:51 PM
p8md
external usenet poster
 
Posts: n/a
Default

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  
Old December 21st, 2004, 02:24 AM
Marshall Barton
external usenet poster
 
Posts: n/a
Default

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  
Old December 21st, 2004, 04:59 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 08:58 PM


All times are GMT +1. The time now is 02:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.