Gustav Brock
Gustav at cactus.dk
Fri May 6 12:18:32 CDT 2005
Hi Debbie Is this happening at the customer's site? Did you open the report at the customer in design view, change paper size, save, open, and print? /gustav >>> DElam at jenkens.com 05/06 6:40 pm >>> I have a report that has been on legal size paper for quite a while. Now, I am being asked to condense it (virtually illegible, but that is what the customer wants) onto letter size paper. I have condensed the report and made the report width narrower so that it will fit on letter paper, however, the report still prints on legal. Page setup says letter, and in fact will not allow any other size to be saved. Changing printers has not stopped the report from printing on legal size paper, I have even tried importing it into a different database to see if that would fix it. This is tremendously strange, especially considering that normally I have the opposite problem. Access tends to make every report letter size if the printer changes. I am rapidly approaching the point where I am ready to re-create the report from scratch, but I am hoping that one of you knows what is going on and can direct me to a fix. I am using Access 2002 and a SQL 2000 back end. Debbie