If 2 fields the same, print only one

  • Thread starter Thread starter Laurie
  • Start date Start date
L

Laurie

Hi,

I have a database with two field with similar data. Some
times they are the same. I have a columnar report with
one field listed below the other. I want to only include
both when they are different. If only one is included I
want the section to shorten up (so as to shorten the
report in total).

Is this possible?
 
Laurie said:
I have a database with two field with similar data. Some
times they are the same. I have a columnar report with
one field listed below the other. I want to only include
both when they are different. If only one is included I
want the section to shorten up (so as to shorten the
report in total).
Click to expand...


These fields are in the same record, right? If so, then
just us a little code to Make the ones you don't want to see
Invisible and set the text boxes and the detail section's
CanShrink to Yes so their space is reclaimed:

A1.Visible = Not IsNull(A1)
A2.Visible = Not (IsNull(A2) Or A2 = A1)

B1.Visible = Not IsNull(B1)
B2.Visible = Not (IsNull(B2) Or B2 = B1)
 
Back
Top