Report Field Parameters via VBA code 1

[Vidar13]

I have a report that I want to be able to change the layout via code, from data supplied from a table. I'm trying to change the top/left positing of the report fields on the fly to meet the demands specified in a parameter table.

It doesn't appear there are any field positioning controls that are available in the report load event?? Is there another way to go about this?

 

[MasterPO]

Every control on the report has a 'Top', 'Left' and 'Width' property that can be set via code. The 'Top' and 'Left' properties refer to the control's position within a report section. See online Help for details on these properties.

 

[VBslammer]

You need to handle this in the 'Format' event for the particular section the controls reside in. For example, this code moves and makes visible an OLE control in the first Group Header section:

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
  If Me.Total > 20000 Then
    Me.OLEBound10.Properties("Left") = 200
    Me.OLEBound10.Visible = True
  End If
End Sub

VBSlammer

Unemployed in Houston, Texas