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

  • Thread starter Kevin Beck via AccessMonster.com
  • 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
 
O

Ofer

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
 
B

bdhsd

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.
 
Top