Suppress Line Printing

D

Dave

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

*
 
D

Dave

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

*
 
Top