?
Solved

Access hide/skip report page on condition

Posted on 2008-10-02
1
Medium Priority
?
293 Views
Last Modified: 2012-05-05
Hi experts,

how would you skip or hide a page based on a value on a control on the page? lets say I have a control Accbalance and if it's a negative value skip that page from printing.

Thanks
0
Comment
Question by:1desman1
1 Comment
 
LVL 10

Accepted Solution

by:
slamhound earned 2000 total points
ID: 22631194
You could use the OnPage event of the report and set the visible property of everything on the report to False.


    If Accbalance < 0 Then
        Me.Title.visable = False
        Me.Something.Visible = False
    Else
        Me.Title.visable = True
        Me.Something.Visible = True
    End If

Open in new window

0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

830 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