***//Report width is wider than page width

[jhsurti]

I have been trying to create this report and every time i get this error:
"The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank"

My page set-up has a custom page of 5.5"(w)x8.5"(h). Margins are set to Left, Top and Bottom - 1" and Right 0.5". The widest textbox in the details section is 3.5". Yet I get this error. So i tried creating another report in design view and without adding any control in it, I checked the preview. And I got the same error.
What is the problem. Why do I get this error and how can I rectify it?
I have made it sure that the white page width is no more than 5.5" and also the height totals to 6.25"(1" top margin + 0.5" page header + 0.5" report footer + 0.75" bottom margin + 3.5" details section). There are no line controls that may be going out of range or anything like that.
I need the solution because I am tired of bringing up the print dialog box every time and select pages to print 1 to 1.
Thanks

 

[neileg]

The error message is telling you that your page is too wide, but that there is nothing in the extra width. So checking your text box size is not addressing the problem. The page width is indicated in the design view by the grey background. You will see that this is wider than it needs to be to hold your text boxes. Narrow this by dragging the edges inwards. The page size here must match the page size of your printer (or be smaller).

 

[jhsurti]

I have tried what u suggested with no difference. It still shows the same error.
Is there a code which I can try using in a debug window to get various widths etc of all controls on the form along with the page-layout dimensions?
Just a thought. May be I can find out the culprit that way!

 

[jtvcs]

You know the odd thing about your request is that you created a second report with the same results. Usually this occurs when you've 'messed with' the report design and move a few things around causing that 'extra space' in the grid area that has no controls. NEIL's suggestion is generally the fix. Is it possible that the printer you're using (set as default) is the culprit ? JT

 

[jhsurti]

I use HP Laserjet 6L printer with its own drivers.
The problem does not occur if I change the page size to 8.5" x 11".

 

[neileg]

Few points
1) Why are you using the custom page size? Are you actually printing on this size paper?
2) Your reply about the LJ6L suggests that you think there is no connection between your report design and the printer. That is not the case. The message you are getting is telling you that what you have on screen will not fit on the paper. Access uses the printer drivers to determine the printable area on the page.
3) Changing the paper size to 8.5 x 11 will solve the problem, since the problem is that your report is too wide for the smaller paper (assuming that 8.5" is wide enough). This is not a strange result!

The ruler along the top of your report tells you the page width. With your custom size this should be no more than 4". What is it showing?

 

[jtvcs]

Maybe you could attach a dB with the Report(s), and what you're using to drive the report data-wise (query, table). Then someone can have a look at it. HTH JT

 

[jhsurti]

I am attaching a file with some records. I have removed all irrelevant tables and queries and forms. There is a module which generates the string necessary to write the certificate for the report. A textbox in the report gets the data from this function. I need to use the specified size of paper(5.5" x 8.5") because that is my printed letterhead on which I issue certificates to my patients.
Hope someone can help me out.
Thnx a lot.

 

[Rich]

Post a 97ver

 

[neileg]

Your report is 4.23 inches wide, but you only have a printable area on your page of 4.00 inches.

Like I said in the beginning, you need to narrow your report to the width of the printable area on your page. This is the defined width, 5.5 minus the margins of 1 and 0.5 which give 4.00 inches

 

[jhsurti]

As you must have seen in the page set up I have a left margin of 0.75" and right margin of 0.25" giving a printable width of 4.5". Still after reducing the width to 3.9" also I get the same error.
Any explanation for that?
There is something wrong with my design but I cannot pinpoint the problem.
Because I just now created a new blank report and one textbox with same width and page set-up and it seems to be working. But I'll have to check it on the another PC because my this PC has different configuration and a deskjet HP printer.

 

[neileg]

At last!

If you go into the page setup and check the column width tab you will see it is too wide. Click the check box to set it the to the same as detail, and the problem goes away.

 

[jhsurti]

Thanks a lot for all your help.

 

[gkaste]

If you set page margins in access, will that information save with the database?

I am desigining a database, so I made a really nice form, which is about the width of a computer monitor running 800x600 minus the scroll bars and that stuff. I just saved as a report, and I can print it if I take the margins down on each the left and right side to .15 inches. I dont want to have to tell everyone to setup their printer every time they print, nor will they remember too. So if this can save the page margin info, I wont have to rewrite the report.

Sorry...dont have another machine with access anywhere, or I would test this.

Thanks
Garrett

 

[gkaste]

Anyone, please?

 

[neileg]

Why didn't you start a new post instead of tagging onto an old one? You'll get a better response!

Access and printers is a source of problems. Basically, the printer settings save with the report, not the database, so you have to set them for each report. However, there is no guarantee that on a different machine with a different printer that any given settings will still work.

Good luck

 

[jtvcs]

Page setup 'settings' ARE saved with the report design itself. JT

 

[gkaste]

Why didn't you start a new post instead of tagging onto an old one? You'll get a better response!

Because that is a problem with forums, people 1) fail to use the search function, and 2) make repetitive posts.



Thanks all for your answers.

 

[neileg]

Because that is a problem with forums, people 1) fail to use the search function, and 2) make repetitive posts.

Ah, well. Happy to have helped

 

[im4gltr]

To anyone who may be out there. I read this thread with regard to report width and I'm having the very same problem......The only thing is I've tried all of the suggestions and the pitiful part is the very first one seems to make the most sense to me, but I can't even find the edges to drag in order to narrow the report. When I look at the "column" width and change the width and height to match my paper size, it does nothing to the size of my report. I'm in a little bit of a crunch with time and I'm pretty new to Access-all versions. I have 2010. If anyone can help me, I would really appreciate it. If you take a look at my introduction, you'll see, I'm pretty SLOW, so using language for a 3rd grader, if you please.....Thanks in advance!!