Moving a box at runtime

[Len58]

I have a box on the report footer. I want to move it to the right depending on a grand total. How can I do this? I have tried the move method of the control, but it is not working for me. I don't get an error, the box moves, but regardless of the number it always moves to the same spot.

Thanks.

ie:
Box64.move(1400)

 

[genomon]

Try changing values for the Top & Left properties.

Cogito eggo sum – I think, therefore I am a waffle.

 

[Len58]

There are no Top and Left properties in the reportfooter on Format event. This is my problem.

Thanks.

 

[dhookom]

You would use code in the On Format event of the section containing the box. The Grand Total should also be bound to a control in the same section. The code might look like:

  If Me.txtGrandTotal >= 1000 Then
      Me.CtrlMyBox.Right = 7200 ' about 5 inches
  End If

Duane
Hook'D on Access
MS Access MVP

 

[genomon]

There are no Top and Left properties in the reportfooter

These are properties of the control, not the section.

Cogito eggo sum – I think, therefore I am a waffle.