Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Report Formatting

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
    Else
        Me.RxLine.BorderColor = 0 'Black
    End If
   
End Sub


How can I execute this?

Thank you.
0
thandel
Asked:
thandel
  • 2
1 Solution
 
PatHartmanCommented:
You are using the wrong event.  You need to use the Format event of the section that contains the RxLine control.
0
 
thandelAuthor Commented:
Thanks I didn't even thinkknow of that.
0
 
PatHartmanCommented:
You're welcome:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now