hide objects on a report based on condition in a cell...?...

  • Thread starter Thread starter Kevin Beck via AccessMonster.com
  • Start date Start date
K

Kevin Beck via AccessMonster.com

Hello,

I have a report detailing sales info from specific customers printed out on
3x5 index cards. I have two fields, one with the original purchase and a
second with additional purchases, each separated by a line.

james hatman
------------
1 space
------------
1 marker


Not all customers make a second purchase, so I was wondering if in the
report, some objects might be able to remain hidden if the field in the
table or report is left null,

james hatman
------------
1 space

Here the line is hidden if the additional purchase field is left blank.
Any input on this greatly appreciated,

Thanks,
Kevin
 
On the "on print" event of your detail add the code

if isnull(Me.field1) then
me.field2.visible=false
else
me.field2.visible=true
endif
 
i want to do something similar. i have a field, "ATTN:" in my label report.
some addresses do not have the attn field.

using this code i can make it so that the attn line does not print if there
is no information in that field. but what i REALLY want to do is have the
second line of my address be

ATTN: {ContactName}

so is there a way to do that? i've tried a couple of things and it seems
the "ATTN:" will never print at all, even in the records that have a name on
that line.
 
Back
Top