A
Alan Z. Scharf
Hi,
I'd like to set the distance from Top of a subreport at Runtime, depending
on the contents of a Detail field
I've tried the code below plus variations , but the effect is to blank out
the subreport entirely on the parent report for every detail record.
Is this possible to do at runtime?
Thanks.
Alan
Code
------------------------------------------------------
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.ParCode = "PCPG" Then
Me.Controls("srptFundIDsCrosstab").Properties("Top") = 6.875
Else
'Me.Controls("srptFundIDsCrosstab").Properties("Top") = 8.5833
End If
End Sub
I'd like to set the distance from Top of a subreport at Runtime, depending
on the contents of a Detail field
I've tried the code below plus variations , but the effect is to blank out
the subreport entirely on the parent report for every detail record.
Is this possible to do at runtime?
Thanks.
Alan
Code
------------------------------------------------------
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.ParCode = "PCPG" Then
Me.Controls("srptFundIDsCrosstab").Properties("Top") = 6.875
Else
'Me.Controls("srptFundIDsCrosstab").Properties("Top") = 8.5833
End If
End Sub