Controls are moving on the Detail area ?

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hi,

I have a very serious problem. I created a report (normal report, no special
effects).
There is a header area - where the labels for the colums are. and edit boxes
in the detail area.

The problem is that when I activate the report the first page apears ok, but
all the pages afterwards apear when the detail area is shifted to the left.
All the edit boxes are moved the the left of the page and it creates a mess
in the report.

What might be the problem ?

Daniel
 
Hi Daniel. Have never seen anything like that. Ideas that come to mind
include a corruption of the database, bad code, or a faulty printer driver.

Firstly, if you are using Access 2000 or later, make sure the Name
AutoCorrect boxes are unchecked under:
Tools | Options | General.
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html
Then compact the database:
Tools | Database Utilities | Compact

Next thing would be to double-check that there is no code in the report's
events that are modifying the properties of the controls (e.g. Left), or the
PrtMip of the report.

If the problem remains, try setting a different default printer (checking
File | PageSetup to ensure that the report is not already designated for a
specific printer.) You do not need to buy another printer: just install a
driver. If this solves the problem, then the problem is with the printer
driver, and you will need to get an updated driver from the printer's
manufacturer.

If the problem does not resolve, we are back to the possibility of a deeper
corruption. Open the Immediate Window (Ctrl+G) and enter:
SaveAsText acReport "MyReport", "C:\MyReport.txt"
replacing MyReport with the name of your report. This saves the report as a
text file. Then delete the report (assuming you have a backup of the mdb).
Then compact the database. Then enter this in the Immediate Window:
LoadFromText acReport "MyReport", "C:\MyReport.txt"

Let us know how you go.
 
Well, I checked the article you sent. It's relevant to Access 2000.
I have XP Developer installed with all the latest updates.

Regarding the printer:
1. I Have an HP DeskJet 720C, and HP sais that the driver supplied with
WinXP is the latest available (This is the one I have).

2. I changed the default printer to be my Fax Printer - did the same.
3. I installed a new printer HP LaserJet 5 to a FILE port - didn't help.

I noticed that the controls that move are those located above the detail
area. the ones below do not move.
 
didn't help

is there any relation to the fact that my report is written in a language
that is right to left (hebrew) ?

Daniel
 
That may be a factor, Daniel. I have never seen this issue, but I have not
worked with right-to-left languages in Access either.

Is it possible that CanGrow is messing up the horizontal sizing?

Or perhaps someone who has experience with these languages will post a
reply.
 
Back
Top