Suppress a line of print

  • Thread starter Thread starter Ronald W. Roberts
  • Start date Start date
R

Ronald W. Roberts

Access 97
I want to suppress 1 line of print in a group heading if there is no
data in the line.
The group has 3 textbox controls each print as a seperate line. I want
to suppress
the prerequisite line if there is no data.
Course Name
Description
Prerequisite

Thanks,
Ron
 
You can set its CanShrink property to True, or you can make it only a line,
and set its CanGrow property to True.
 
Ronald,

An alternative to shrinking and growing controls is to use
the + sign to join various fields in one control.
The + will include the chr(13) and chr(10) if there is
data in the field. The following example is one from an
address block where not all address lines are always
populated.

=[first name] & (Chr(13)+Chr(10)+[address line 1]) & (Chr
(13)+Chr(10)+[address line 2]) & (Chr(13)+Chr(10) &
[locality] & " " & [state] & " " & [postcode])

HTH,

Terry
 
Ronald said:
Access 97
I want to suppress 1 line of print in a group heading if there is no
data in the line.
The group has 3 textbox controls each print as a seperate line. I want
to suppress
the prerequisite line if there is no data.
Course Name
Description
Prerequisite

Thanks,
Ron
Click to expand...

Douglas,
I haven't been able to get the can grow/shrink to work.
But after reading yours and Terry's reply , I started thinking about
making the
height of the textbox very small . I will test this tonight.

Terry,
I will also test your routine. I always forget about the plus sign vs
the & sign.

Thanks to both for your reply,
Ron
 
Ronald W. Roberts said:
Douglas,
I haven't been able to get the can grow/shrink to work.
But after reading yours and Terry's reply , I started thinking about
making the
height of the textbox very small . I will test this tonight.
Click to expand...

Just a comment. If you've got more than one field on the row, then Can Grow
will not necessarily work.
 
Back
Top