Suppress Line Printing

G

Guest

I would like to suppress printing a line if a calculated value on that line = 0

thanks,
 
S

strive4peace

Hi Dave,

in the OnFormat event of your Detail section (I am assuming
that is where the line is):

'~~~~~~~~~~~~~~~~~~~
me.Detail.visible = _
IIF(me.controlname = 0,false,true)
'~~~~~~~~~~~~~~~~~~~

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
G

Guest

Crystal...

Thank you!!!!!!!

dave



strive4peace" <"strive4peace2006 at yaho said:
Hi Dave,

in the OnFormat event of your Detail section (I am assuming
that is where the line is):

'~~~~~~~~~~~~~~~~~~~
me.Detail.visible = _
IIF(me.controlname = 0,false,true)
'~~~~~~~~~~~~~~~~~~~

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
Click to expand...
 
S

strive4peace

you're welcome, Dave ;) happy to help

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to suppress printing reports that contain no data is select fi 1
Suppress total for first record of a group 1
How to Suppress Report Line Containing Label But With Blank/Null D 2
Suppress individual Group Header Lines 4
Suppress Printing with Character in Excel File 2
suppress same information for the row 1
How suppress detail line if condition met 3
suppress printing line in report 10

Top