White Space?

[scouser]

Report Format Problem?

I have had a search of the Reports Forum and was unable to find an answer to my problem. What is it. Well nothing major, but irritating none the less.
I have a report 'Invoice'. Between the Page Header and Page Detail section there is a gap of about 1 inch of white space? I am unable to figure out why? I have tried all sorts of fixes. The attached jpegs explain all. One captures the report in Print Preview Mode, the other Deign Mode.

Anybody else had this before? Help appreciated?
Thanks in advance,
Phil.

 

[PARSO]

move the headings out of the page header and into the header below, called Service price header

 

[scouser]

Not the answer!!

Parso cheers for replying. Unfortuantly that was not the answer as in doing that the Headings appear for each order line + there is still a huge void? See attached jpeg.
Regards,
Phil.

 

[scouser]

Happy Now

I have now put all the Address Details in the 'Report Header' section. The Column Headings in the 'Page Header', the Order Details in the 'Detail' section and the Totals in the 'Page Footer'.

If anybody can think of a better solution please let me know!!
Cheers,
Phil.

 

[mresann]

I have been unsuccessful in trying to replicate your problem. Can you post a zip of the mdb file with just the report and the tables with sample data? I've personally never had a formatting problem with reports similar to your conundrum. Include all relevent queries and code modules that populate data for the report. Make sure eata you send is either dummy or non-confidential in nature. Thanks

 

[cavscout]

You don't by any chance have a blank record in your query results somewhere that is inserting a blank line?

Sorry if this is very basic but often we overlook the simple. We've all had the support call from the guy who's computer doesn't work and after troubleshooting everything else we discover he never had it plugged in.

 

[scouser]

Hello

Hi Guys. No blank records as the form that calls the report is 'Single', so there is only one record per report.

I will attempt to scale down DB and post for your viewing!!
Cheers,
Phil.

 

[scouser]

Database Attached

Database attached as requested.
Regards,
Phil.

 

[cavscout]

When I click the print invoice button, my invoice looks fine.

When I click the preview invoice button, it previews fine.

Sorry I don't see any problems like you've described.

I'm running Windows XP Pro and Access 97.

 

[scouser]

Problem

Cavscout, quite right no problems because:

I have now put all the Address Details in the 'Report Header' section. The Column Headings in the 'Page Header', the Order Details in the 'Detail' section and the Totals in the 'Page Footer'.

If anybody can think of a better solution please let me know!!

Thanks for looking.
Phil.

 

[scouser]

Report Format

OK. I have changed the report so the Header appears on every page. I have the Invoice Number etc in the Page Header. Order Details in the Detail Section. There is a gap of around 1 inch of white space between the Column Headings and the first Order Detail Record?

I have attached a sample database.
Open and select Print Preview to view the Invoice Report.
Thanks for any advice, help.
Regards,
Phil.

 

[razorking]

I think it fixed but not sure what the actual cause is/was:

I started the patented screw with it until you figure it out approach and was able to determine that if you remove the - address2/address3/city/county/postal code - text boxes it will suck it right up there like you would expect. I then went back and recreated new ones and it all stayed like we want it to.

Anyway I am curious as to what it is about those controls that are hoseing things up.

let us know if you find out.

see how this looks

 

[scouser]

Report

Raz cheers for your efforts. I have nailed the problem. If you set the Address Fields properties 'Can Grow' 'Can Shrink' to 'Yes' then hey presto White Space?
The more address fields you set, the bigger the sapce? Weird. Still at least we know the cause!!
Once again, thanks for your efforts.
Phil.

 

[scouser]

Can Grow Can Shrink?

If I set the values of my Address Fields 'Can Grow' 'Can Shrink' to 'Yes' so blank lines are omitted from the report, a void (white space) appears between the 'Page Header' and 'Detail' section? (see jpeg)

Does anybody know a fix for this problem?
Cheers,
Phil.

 

[razorking]

How about just concatenating the three address field on the query that is the source for the report. Then you could just have on text box on the report for the three fields. Or could you possibly concatenate the city, count, postal code fields?

The third alternave to me would be to just set the text boxes to not be able to grow and then make them sufficiently wide to print any text straight across the page.

I would try that and see how it looks with some test data.

 

[PARSO]

ok try this

move the address and all other info into the report header.
But leave the column headings in page header
then move around the distance betwen each header to where u want it.

(if u want it to all stay on one page and not get the margin error drag the white background inward to the left) if u didnt alredy know

hope it helps

 

[scouser]

Cheers

Thanks guys.......................