H
Humphrey
I have a detail section that contains a photo and a text box and under them
in the same section are another photo and text box. If both the second text
box and photo are blank I want to make them both invisible and have the
detail section reduce in size.
I've written the VBA to set the properties of the second set to invisible
and housed it in the Detail_Print section. The problem is the effect is not
felt until the next record. That is if the detail should hide the photo in
the current record, it is the following record that has it hidden and if it
should be shown in the current record it is the following record that has it
shown.
I understand why it doing what it is doing, my question is how do I get it
to determine whether the photo should be hidden in the current section and
make the appropriate changes?
H
in the same section are another photo and text box. If both the second text
box and photo are blank I want to make them both invisible and have the
detail section reduce in size.
I've written the VBA to set the properties of the second set to invisible
and housed it in the Detail_Print section. The problem is the effect is not
felt until the next record. That is if the detail should hide the photo in
the current record, it is the following record that has it hidden and if it
should be shown in the current record it is the following record that has it
shown.
I understand why it doing what it is doing, my question is how do I get it
to determine whether the photo should be hidden in the current section and
make the appropriate changes?
H