Report width will not shrink

M

M Skabialka

I have a report that was originally designed as legal size, but by
eliminating a few columns is now landscape letter size. However I am unable
to shrink the width from 12" to 9" - there seems to be something invisible
to me in one of the headers, footers or detail sections. I have tried
everything to try to select whatever it is that is 12" wide but am unable to
find it. I have tried CTRL A for select all, tried highlighting from the
top or the side, etc but nothing shows up. It has to be a line or
something, but when I preview the report the second page is blank. I can
get around it in page setup by telling it the width is 9", i.e., not the
same as the detail, but would prefer to find and eliminate this annoying
component of my report!
Thanks,
Mich
 
M

M Skabialka

I have to admit I was skeptical, but I highlighted the whole thing and
pasted it into a blank report - it zipped all the way to 12" immediately, so
then I tried one section of the report at a time and found the offending
section - the detail header. I then was able to find and select the line
that was 12" wide, and actually found it was 3 lines superimposed on each
other! When I got rid of all of them the report was able to shrink to the
right width. I do not know why I wasn't able to find the lines when I didn't
know exactly where to look - so thanks for the excellent suggestion which
solved my problem!

Mich
 
M

Michael

Did you try selecting the controls you need, pasting them to a new report,
and saving that report?

Not sure if that is possible for you but that's a good way to fix many
problems that do not seem to bare a good explanation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top