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  

Layout



 
 
Thread Tools Display Modes
  #1  
Old August 6th, 2007, 02:18 PM posted to microsoft.public.access.reports
Dale
external usenet poster
 
Posts: 292
Default Layout

I need some help if anyone has any ideas. I have a preprinted form that I am
trying to generate a report to put the data into when printing. The form is
laid out like this.
1 include margin at top and bottom. Leaving 9 inches in the middle. The data
is broken into 3 sections on the form. Each being 2 inches tall for the boxes
on the form. Then between the boxes is 1 1/2 inches of blank space. I can get
the first 2 to fill in correctly but have not figured out how to get the 3rd
to show up. So basically i have this

1" top margin
2" data box
1 1/2" blank space
2" data box
1 1/2" blank space
2" data box
1" bottom margin.

Any ideas on how to get a report in access to handle this since using a 1"
top margin and a report of 3 1/2 inches will not work since it goes over 11
inches? Any help is appreciated
  #2  
Old August 7th, 2007, 04:52 PM posted to microsoft.public.access.reports
Dale
external usenet poster
 
Posts: 292
Default Layout

I was able to do this by setting the detail section height to 3 1/2 inches
and then to 2 inches based on the record count in the detail format. I also
had to add a page break and set it to visible after the 3rd record each time
through.

"Dale" wrote:

I need some help if anyone has any ideas. I have a preprinted form that I am
trying to generate a report to put the data into when printing. The form is
laid out like this.
1 include margin at top and bottom. Leaving 9 inches in the middle. The data
is broken into 3 sections on the form. Each being 2 inches tall for the boxes
on the form. Then between the boxes is 1 1/2 inches of blank space. I can get
the first 2 to fill in correctly but have not figured out how to get the 3rd
to show up. So basically i have this

1" top margin
2" data box
1 1/2" blank space
2" data box
1 1/2" blank space
2" data box
1" bottom margin.

Any ideas on how to get a report in access to handle this since using a 1"
top margin and a report of 3 1/2 inches will not work since it goes over 11
inches? Any help is appreciated

 




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


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