Display multi phones in record & Set static display 1

[cottontop]

Hi!

Hope this isn't too easy and waste ur time, but I need some guidance.

An account number is the key field. Each account can have between 2 and 4 lines.

Ok, displaying all the lines for each account... easy!

However, I would like to display only 20 accounts to each
page and have equal distance between the accounts.

EXAMPLE:
-----------------------------------------
account1 address city state zip
phone1
phone2
[blank line for no phone3]
[blank line for no phone4]
------------------------------------------
account2 address city state zip
phone1
phone2
phone3
phone4
--------------------------------------------
account3 address city state zip
phone1
phone2
phone3
[blank line for no phone4]
----------------------------------------------

new page after 20 accounts! (or whatever fits best!)

Help... Anybody!

BTW.. K.I.S.S.

TIA

 

[dhookom]

Do you have 4 phone fields or are the phone numbers in separate records?

Duane
MS Access MVP

 

[cottontop]

4 separate records linked by account

 

[bhoran]

You can use the keep together property to ensure the header and detail print on the same page for each account but sorry I don't know how you specify the number of accounts per page.

Cheers

 

[dhookom]

Create a main report with the Account only (no phone details). Then create a subreport based on the Phone numbers. Add the subreport to the main report and set its height to the size of 4 records and set it to not grow or shrink. Make sure you link the Master/Child to the Account field.

Duane
MS Access MVP

 

[cottontop]

Thanks Duane...

In doing what you stated allows for 12 accounts to be printed on one page and I only want 10... how do I control that?

 

[PaulBricker]

You can control the number of accounts on each page using this method. Add a texbox to your Main Report (I'll call Text1). Set the Control Source to =1. Set the Running Sum property to OverAll. Set the Visible property to No. Add a PageBreak to the Main Report below the Subreport. In the Format Event for the section the Subreport is in put this code.

If Text1 Mod 10 = 0 Then
Me.PageBreakName.visible = True
Else
Me.PageBreakName.Visible = False
End If


That should do it.

Paul

 

[dhookom]

Or, if you used a subreport, just set the top and bottom margin (or other sections) larger so they fill the page.

Duane
MS Access MVP