Report alignment problem

[Karen]

I have a report to be printed on a standard piece of paper 8 1/2 x 11.

On the left side of the report there are several text fields which are
aligned to the left. The text fields extend from the top of the page to the
bottom of the page.

On the right side of the report, I have two subreports; one is for notes,
the other is for phone log entries. The length of the subreports depends on
the number of notes or phone calls

I want the report to look like this

text1 Phone Log
text2 phone call 1
text3 phone call2
text4
text5
text6 Journal
text7 Note1
text8 Note2

BUT when the phone subreport becomes long enough that it pushed the Note
subreport down, the text fields develop a large gap like this

text1 Phone Log
text2 phone call 1
text3 phone call2
phone call3
phone call4


text4
text5
text6 Journal
text7 Note1
text8 Note2


Help!

 

[Duane Hookom]

Consider making the records down the left side into a subreport also.

 

[Karen]

Duane,

Thanks, besides being sort of voodoo fix, do you know why it was changing
the alignment?

--
Karen

Consider making the records down the left side into a subreport also.

--
Duane Hookom
MS Access MVP

I have a report to be printed on a standard piece of paper 8 1/2 x 11.

On the left side of the report there are several text fields which are
aligned to the left. The text fields extend from the top of the page to the
bottom of the page.

On the right side of the report, I have two subreports; one is for notes,
the other is for phone log entries. The length of the subreports

depends

 

[Yuan Shao]

Hi Karen,

If I learned correctly when the phone subreport becomes long enough, it
pushed the Note subreport down and the text fields develop a large gap.
Based on my experience, this problem is mostly related the report design.
Can you please detailed describe your report design and the underlying
data? It is appreciated you can create a sample on the Northwind.mdb so
that I can fully understand your concern.

Only according to the sample data you provided, it is possible you can
design the text, phone log and Note in one report without subreport. Does
it make sense?

I am looking forward to hearing from you soon.
Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Karen]

Hi Michael,

I just don't have time to duplicate in Northwind but here is the structure
of the report.

The report is tied to a table with information regarding a case. On the
report, on the left side, I had several text boxes which were bound to
fields in the case table. Each case will have some number of associated
phone calls and Notes. In the right hand side of the report I had a
subreport of the Phone calls and another for the Notes. The subreports were
linked to the main report by the CaseID which is stored in the PhoneCall and
Notes tables as a foreign key.

I checked that the width of the textboxes on the left side did not extend
into area of the subreports on the right side, they did not.

When I ran the report, if the number of phone calls caused the phone call
subreport to grow, a large gap between text fields on the left side
occurred.

Duane suggested that I put the text fields in a subreport also and now the
problem is resolved to the satisfaction of my client.

Still.............it would be nice to know why the growth of the phone call
subreport affected the placement of the text boxes on the left side of the
report.

 

[Duane Hookom]

The growth of any control will push down any controls where their top
property is higher than the bottom of an expanding/growing control.

 

[Karen]

Duane,

Thanks very much. I sure never could have figured out that property. The
subreport has fixed this for me.