Posted on 2013-11-22
I have report that I am changing various field and formats based on opening arguments and data criteria.
I would like to a hide a line on the report "RxLine" under conditions. I am to hide it by setting is border color to white. I have used this technique in the past. The report is called from a form.
I am trying to get the following to execute but it is not. I have tried it under page activate as well.
Private Sub Report_Activate()
If [JobType] <> "Rx" Or [OpenArgs] = "PT" Then
Me.RxLine.BorderColor = 16777215 'White
Me.RxLine.BorderColor = 0 'Black
How can I execute this?