Solved

Report Formatting

Posted on 2013-11-22
3
232 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 36

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 36

Expert Comment

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

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access question 3 41
Null or "" 28 51
Specify the table containg the records you want to delete 14 29
auto-fill field(s) in Access data entry form 17 40
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

679 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