Trouble with line spacing and Can Shrink/Can Grow

Hello,

We have a basic report that prints a customer's name followed by their order
detail lines (part#, qty, price, ext price, etc). We setup the detail
section to print the rows tightly together like we want. To ensure that all
customers appear on the report -- even those without orders -- we use a
query to LEFT JOIN the Customer file to the Orders file. However, customers
without orders have a blank detail line and we want to eliminate that wasted
space. We are running into trouble though and here is what we tried (btw,
there are no graphics/lines in the detail section)

1. Set Can Shrink=YES for the detail section. That didnt eliminate the blank
lines.

2. Set Can Shrink=YES for the controls in the detail section. That results
in no detail lines printing for ANY customer, even those with orders. Where
the orders should have printed, only white space now appears. For example,
if the customer had 10 order lines there are now 10 lines of white space for
that customer.

3. Set both Can Shrink=YES and Can Grow=YES for the controls in the detail
section. This did eliminate the blank line for customers without orders as
we wanted, and did print the order details for other customers too. However,
the detail lines are now not tightly grouped together.

I would like to eliminate those blank lines for orderless customers AND keep
the detail lines tightly together for customers who do have orders. Can
anyone tell me if this is possible.

Thanks, Suzi

"Suzi Carr" wrote in message
news:tF9Lc.1$A%3.0@lakeread04...
Hello,

We have a basic report that prints a customer's name followed by their
order
detail lines (part#, qty, price, ext price, etc). We setup the detail
section to print the rows tightly together like we want. To ensure that
all
customers appear on the report -- even those without orders -- we use a
query to LEFT JOIN the Customer file to the Orders file. However,
customers
without orders have a blank detail line and we want to eliminate that
wasted
space. We are running into trouble though and here is what we tried (btw,
there are no graphics/lines in the detail section)

1. Set Can Shrink=YES for the detail section. That didnt eliminate the
blank
lines.

2. Set Can Shrink=YES for the controls in the detail section. That
results
in no detail lines printing for ANY customer, even those with orders.
Where
the orders should have printed, only white space now appears. For
example,
if the customer had 10 order lines there are now 10 lines of white space
for
that customer.

3. Set both Can Shrink=YES and Can Grow=YES for the controls in the
detail
section. This did eliminate the blank line for customers without orders
as
we wanted, and did print the order details for other customers too.
However,
the detail lines are now not tightly grouped together.

I would like to eliminate those blank lines for orderless customers AND
keep
the detail lines tightly together for customers who do have orders. Can
anyone tell me if this is possible.

You can't except to use a smaller font. When CanGrow is enabled the
TextBoxes will always go to their default height for the given font.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com