Solved

Report Formatting

Posted on 2013-11-22
3
228 Views
Last Modified: 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
    Else
        Me.RxLine.BorderColor = 0 'Black
    End If
   
End Sub


How can I execute this?

Thank you.
0
Comment
Question by:thandel
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 39669047
You are using the wrong event.  You need to use the Format event of the section that contains the RxLine control.
0
 

Author Closing Comment

by:thandel
ID: 39669341
Thanks I didn't even thinkknow of that.
0
 
LVL 34

Expert Comment

by:PatHartman
ID: 39669562
You're welcome:)
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now