I have been working with Access for years.
I have written routines that reposition controls and subreports by using MoveLayout
Now I'm using Windows XP, Office 2003 and Access 2003.
Also I have installed Access97
Creating a new MDB with just a report with some header-text and, and in the Detail section a Textbox called 'Textbox1' with a control Source: ="Empty value",
I try to move this control down when formatting or printing the Report.
For this I use following code.
- Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
-
Debug.Print Me.Textbox1.Top
-
While Me.Textbox1.Top < 2000
-
PrintSection = False
-
NextRecord = False
-
MoveLayout = True
-
Debug.Print Me.Textbox1.Top
-
Wend
-
End Sub
As I have used some similar before, this should work.
But it doesn't. The Textbox1.Top is 120 and stays 120.
Does anybody know what may be wrong here?
