Suppress a line of print

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
 
D

Douglas J. Steele

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

Guest

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
 
R

Ronald W. Roberts

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
 
D

Douglas J. Steele

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