Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / February 2008

Tip: Looking for answers? Try searching our database.

Dont force a Blank Page if Field is Null !!!!!! Please Help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TheNovice - 29 Feb 2008 20:35 GMT
Hello again,

Asking for some expert advise.  I have a report that has two sections both
with headers and footers.  in the final footer I have a unbound field that if
the check box is true show the field, if false, Null.  it wiorks great, but
here is my problem.  that footer need to pring on the second page and it will
if I "Force New Page"  but if it is null it gives me a Blank page.  I tried
the grouping and Page Breaks and Footer Properties but they all seem to do
the same thing or it doesnt.

Please help!!!!

Signature

-The Novice
Learn Today, Teach Tomorrow

Great Success is ones ability to ask for Help.

Marshall Barton - 29 Feb 2008 22:53 GMT
>Asking for some expert advise.  I have a report that has two sections both
>with headers and footers.  in the final footer I have a unbound field that if
[quoted text clipped - 3 lines]
>the grouping and Page Breaks and Footer Properties but they all seem to do
>the same thing or it doesnt.

Try cancelling the footer's Format event when the check box
is not checked:

Cancel = (Me.thecheckbox = False)

Signature

Marsh
MVP [MS Access]

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.