In Access 2007 I get an Error 2100: The control or subform control is too large for this location. This makes no sense because of the following steps that created the error:
1. Create a new database.
2. Create a new report with a single, small textbox in the middle of a large detail section (and some generic control source like = "hello world").
3. Add the following code to the Report:
Private Sub Report_Open(Can cel As Integer)
On Error GoTo errr
MsgBox Me.Controls("tx t1").Top
Me.Controls("tx t1").Top = Me.Controls("tx t1").Top - 1
MsgBox Me.Controls("tx t1").Top
Exit Sub
errr:
MsgBox Err & ": " & Error
End Sub
4. Save the report, close Access, reopen the database, preview the report.
If I keep Access open and run the report a second time, there is no error.
1. Create a new database.
2. Create a new report with a single, small textbox in the middle of a large detail section (and some generic control source like = "hello world").
3. Add the following code to the Report:
Private Sub Report_Open(Can cel As Integer)
On Error GoTo errr
MsgBox Me.Controls("tx t1").Top
Me.Controls("tx t1").Top = Me.Controls("tx t1").Top - 1
MsgBox Me.Controls("tx t1").Top
Exit Sub
errr:
MsgBox Err & ": " & Error
End Sub
4. Save the report, close Access, reopen the database, preview the report.
If I keep Access open and run the report a second time, there is no error.