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  

Making the detail section of a report a set size (regardless of the Number of entries)



 
 
Thread Tools Display Modes
  #1  
Old July 21st, 2004, 01:25 PM
John Ortt
external usenet poster
 
Posts: n/a
Default Making the detail section of a report a set size (regardless of the Number of entries)

I wish to use an access report to print wedding invitations.
The problem lies in the fact that I have anywhere between two entries (Joe
Bloggs & Guest) and approximately 5 entries (Fred Flintstone & Wife & Kid 1
& Kid 2 Etc).

I want to set up an A4 page to print two Invites so I can Guilotine it in
half and produce A5 invites, but I want to assign a set size to the complete
detail section and not each entry in the detail section.

If anybody has any Ideas I would be extremely Grateful.

Thanks In Advance,

John Ortt

I have tried to represent what I want below:

_________________

Invite 1
We want to Invite
YOU
& GUEST
- Spare Name Slot
- Spare Name Slot
To our Wedding
_________________

_________________

Invite 2
We want to Invite
YOU
& WIFE
& DAUGHTER
& SON
To our Wedding
_________________


  #2  
Old July 21st, 2004, 01:53 PM
Rick Brandt
external usenet poster
 
Posts: n/a
Default Making the detail section of a report a set size (regardless of the Number of entries)

"John Ortt" wrote in message
...
I wish to use an access report to print wedding invitations.
The problem lies in the fact that I have anywhere between two entries

(Joe
Bloggs & Guest) and approximately 5 entries (Fred Flintstone & Wife & Kid

1
& Kid 2 Etc).

I want to set up an A4 page to print two Invites so I can Guilotine it in
half and produce A5 invites, but I want to assign a set size to the

complete
detail section and not each entry in the detail section.

If anybody has any Ideas I would be extremely Grateful.


Use a subreport with CanGrow disabled.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


  #3  
Old July 21st, 2004, 02:41 PM
John Ortt
external usenet poster
 
Posts: n/a
Default Making the detail section of a report a set size (regardless of the Number of entries)

Thanks Rick,

Simple solution but I've been racking my brains for days...

Thankyou.


"Rick Brandt" wrote in message
...
"John Ortt" wrote in message
...
I wish to use an access report to print wedding invitations.
The problem lies in the fact that I have anywhere between two entries

(Joe
Bloggs & Guest) and approximately 5 entries (Fred Flintstone & Wife &

Kid
1
& Kid 2 Etc).

I want to set up an A4 page to print two Invites so I can Guilotine it

in
half and produce A5 invites, but I want to assign a set size to the

complete
detail section and not each entry in the detail section.

If anybody has any Ideas I would be extremely Grateful.


Use a subreport with CanGrow disabled.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com




 




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
CONTROLL PAGE MARGINS AND FIELD SPACING Bob H. Using Forms 1 June 15th, 2004 06:51 PM
Changing detail section height Max Moor Using Forms 2 June 6th, 2004 05:13 AM
Suppress Printing of Repeated Values in Report Detail Band Mike Thomas Setting Up & Running Reports 3 June 4th, 2004 02:00 PM
Bug in Access 2002 Reports notbitmonk Setting Up & Running Reports 10 May 22nd, 2004 05:47 PM
Pass a filter from report to subreport Fons Ponsioen Setting Up & Running Reports 0 May 18th, 2004 02:30 PM


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