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  

gap sub report



 
 
Thread Tools Display Modes
  #1  
Old December 29th, 2007, 05:02 PM posted to microsoft.public.access.reports
cjgav
external usenet poster
 
Posts: 54
Default gap sub report

Hi
I am tring to design a report using the format of a repairs claim form
supplied by a customer I am using a sub report to enter the parts used which
is on the right hand of the page. My problem is that the subreport creates a
gap in the report on the left hand side of the form.
Any sugestion how I can remove this gap ?
  #2  
Old December 29th, 2007, 05:45 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default gap sub report

cjgav wrote:

I am tring to design a report using the format of a repairs claim form
supplied by a customer I am using a sub report to enter the parts used which
is on the right hand of the page. My problem is that the subreport creates a
gap in the report on the left hand side of the form.



That sounds like the subreport's CanGrow is pushing other
things down the page. If so, make the subreport control
taller so the top of the other controls are above the bottom
of the subreport control. Maybe(?) set the subreport
control's CanShrink to Yes??

--
Marsh
MVP [MS Access]
  #3  
Old January 4th, 2008, 10:22 PM posted to microsoft.public.access.reports
cjgav
external usenet poster
 
Posts: 54
Default gap sub report

hi
Thanks for your reply i've tried that does but the gaps are still there !
Any more suggestions?

"Marshall Barton" wrote:

cjgav wrote:

I am tring to design a report using the format of a repairs claim form
supplied by a customer I am using a sub report to enter the parts used which
is on the right hand of the page. My problem is that the subreport creates a
gap in the report on the left hand side of the form.



That sounds like the subreport's CanGrow is pushing other
things down the page. If so, make the subreport control
taller so the top of the other controls are above the bottom
of the subreport control. Maybe(?) set the subreport
control's CanShrink to Yes??

--
Marsh
MVP [MS Access]

  #4  
Old January 5th, 2008, 12:00 AM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default gap sub report

You need to identify where the gap is occuring and make the
subreport tall enough so its bottom is below whatever is
moving down the page. If necassary, make the subreport as
tall as possible and set its CanGrow to No.

If that still doesn't clarify the problem area, please
provide some useful information about what is happening.
"the gaps are still there" just doesn't give me enough clues
to understand what is happening.
--
Marsh
MVP [MS Access]


cjgav wrote:
Thanks for your reply i've tried that does but the gaps are still there !
Any more suggestions?

"Marshall Barton" wrote:

cjgav wrote:

I am tring to design a report using the format of a repairs claim form
supplied by a customer I am using a sub report to enter the parts used which
is on the right hand of the page. My problem is that the subreport creates a
gap in the report on the left hand side of the form.



That sounds like the subreport's CanGrow is pushing other
things down the page. If so, make the subreport control
taller so the top of the other controls are above the bottom
of the subreport control. Maybe(?) set the subreport
control's CanShrink to Yes??

 




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 08:39 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.