Hide a line in Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help me to hide a line in the Report if one of the textboxes's value
is Null.

My line contains 4 text fields. They are in the Report header.
Text38 has control source set to: =DLookUp("[PREVs]","[Q_Previous]")

I got the other fields to come out blank setting their control source as
follows:
=IIf(IsNull([Text38]),"","Previous")

But I still get an empty line in my report even though I set the property to
"Can Shrink=Yes".

I believe I have to use some "visible" property thing, but not sure that I
know how to....
Please, somebody show me the way how to do that.

Thank you.
Lana
 
Lana:

Access is going to hold the space on the report for the control. Even
though you set its can shrink value to true, it won't entirely not display,
it will hold to the minimum size of the controls even if null.

The way around this is to use the On print event of the detail section and
the report properties .PrintSection & .NextRecord. So you would add code
like this to the event:

If IsNull([Text38]) Then
Me.PrintSection = False
Me.NextRecord = True
End if
 
How can I define this "section" not to be printed if it is not in "details"
but in the header? I have also other information in the header which I WANT
to be printed. And those 4 fields are printed only once so they have no
possible "next record".

Is there any other way to suppress them if they are null?

SA said:
Lana:

Access is going to hold the space on the report for the control. Even
though you set its can shrink value to true, it won't entirely not display,
it will hold to the minimum size of the controls even if null.

The way around this is to use the On print event of the detail section and
the report properties .PrintSection & .NextRecord. So you would add code
like this to the event:

If IsNull([Text38]) Then
Me.PrintSection = False
Me.NextRecord = True
End if
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg


Lana said:
Please help me to hide a line in the Report if one of the textboxes's
value
is Null.

My line contains 4 text fields. They are in the Report header.
Text38 has control source set to: =DLookUp("[PREVs]","[Q_Previous]")

I got the other fields to come out blank setting their control source as
follows:
=IIf(IsNull([Text38]),"","Previous")

But I still get an empty line in my report even though I set the property
to
"Can Shrink=Yes".

I believe I have to use some "visible" property thing, but not sure that I
know how to....
Please, somebody show me the way how to do that.

Thank you.
Lana
Click to expand...
Click to expand...
 
Back
Top