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.
Expand|Select|Wrap|Line Numbers
- 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
But it doesn't. The Textbox1.Top is 120 and stays 120.
Does anybody know what may be wrong here?