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  

Report Letter



 
 
Thread Tools Display Modes
  #1  
Old August 12th, 2005, 09:47 PM
mattmanp
external usenet poster
 
Posts: n/a
Default Report Letter

I am using a report to generate a letter based on values in a form.
The letter is basically formatted as three parts a top and bottom
part that should stay the same size and a middle part that I would
like to have variable size but not have a big gap between the middle
and bottom part (as in a big textbox that I hope is big enough to fit
everything). Is there a way I can make it so that the larger or
smaller the middle is, the bottom part stays the same distance from
the last line? Thank you and let me know if I was too confusing in my
wording.

  #2  
Old August 13th, 2005, 05:56 AM
Allen Browne
external usenet poster
 
Posts: n/a
Default

For the middle part of your letter, set the Can Grow property of the text
boxes to Yes. These boxes will then grow as needed, and push the lower boxes
further down the page.

In the Northwind sample database, the Invoice report is an example of this
kind of layout.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mattmanp" wrote in message
...
I am using a report to generate a letter based on values in a form.
The letter is basically formatted as three parts a top and bottom
part that should stay the same size and a middle part that I would
like to have variable size but not have a big gap between the middle
and bottom part (as in a big textbox that I hope is big enough to fit
everything). Is there a way I can make it so that the larger or
smaller the middle is, the bottom part stays the same distance from
the last line? Thank you and let me know if I was too confusing in my
wording.



 




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
Convert to Symbols Omar Menjivar General Discussion 7 June 27th, 2005 07:32 PM
Report sets back to letter Fernando Setting Up & Running Reports 0 June 9th, 2005 03:40 PM
Two sided letter (report) question KCi Setting Up & Running Reports 1 January 26th, 2005 08:31 PM
Using Form or Report for letter jocal69 Setting Up & Running Reports 2 August 9th, 2004 10:52 PM
Label SRIT General Discussion 2 June 22nd, 2004 09:42 PM


All times are GMT +1. The time now is 05:25 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.