How to remove row gaps in report ?

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

Guest

Helo,

I have problem in report !!!! I think it can be resolve by NZ Or Nul
Expression but I don't know how?
Problem is_
On report in Detail sec I have 6 rows of controls which refers to tables.
But some time I don't have record in some of the fields. When I print report
there are gaps btween row which is not acceptable. So how can I remove this
gap when there is no record ?

Andy
 
In design view click on menu VIEW - Properties. Click on the text box and
set the Can Grow property to Yes. Then reduce the vertical size to a
hairline. When there is data it will expand to accommodate the information.
 
Thank you Karl. Good Idea.

I have controls in reports like this_

Row 1 _______ ________ __________
Row 2 ______________ _______________
Row 3 _______ _________ ______________

Here Line Indicate differen Controls which refers field of various tables.

If I don't have record in Middle control say in Row 1 then how do I
eleminate gap and move Last Control to middle?

Andy
 
You can stack the text boxes so you have like this ---
111111 23232323 333333
Then in the first number 3 text box make source like this ---
=IIF([2] Is Null, [3], Null)
You may have to play with it a little and make sure they are transparent.
 
Karl Is there any other way like Using Chr(13) & Chr(10)? Cuz I read about
this in this Discussion group But I don't understood it !!!!
Thanks

KARL DEWEY said:
You can stack the text boxes so you have like this ---
111111 23232323 333333
Then in the first number 3 text box make source like this ---
=IIF([2] Is Null, [3], Null)
You may have to play with it a little and make sure they are transparent.
--
KARL DEWEY
Build a little - Test a little


Andy said:
Thank you Karl. Good Idea.

I have controls in reports like this_

Row 1 _______ ________ __________
Row 2 ______________ _______________
Row 3 _______ _________ ______________

Here Line Indicate differen Controls which refers field of various tables.

If I don't have record in Middle control say in Row 1 then how do I
eleminate gap and move Last Control to middle?

Andy
 
I do not know what you read but Chr(13) & Chr(10) are the ASCII characters
for carriage return and line feed so as to force a wrap in a text string.
--
KARL DEWEY
Build a little - Test a little


Andy said:
Karl Is there any other way like Using Chr(13) & Chr(10)? Cuz I read about
this in this Discussion group But I don't understood it !!!!
Thanks

KARL DEWEY said:
You can stack the text boxes so you have like this ---
111111 23232323 333333
Then in the first number 3 text box make source like this ---
=IIF([2] Is Null, [3], Null)
You may have to play with it a little and make sure they are transparent.
--
KARL DEWEY
Build a little - Test a little


Andy said:
Thank you Karl. Good Idea.

I have controls in reports like this_

Row 1 _______ ________ __________
Row 2 ______________ _______________
Row 3 _______ _________ ______________

Here Line Indicate differen Controls which refers field of various tables.

If I don't have record in Middle control say in Row 1 then how do I
eleminate gap and move Last Control to middle?

Andy
:

In design view click on menu VIEW - Properties. Click on the text box and
set the Can Grow property to Yes. Then reduce the vertical size to a
hairline. When there is data it will expand to accommodate the information.
--
KARL DEWEY
Build a little - Test a little


:

Helo,

I have problem in report !!!! I think it can be resolve by NZ Or Nul
Expression but I don't know how?
Problem is_
On report in Detail sec I have 6 rows of controls which refers to tables.
But some time I don't have record in some of the fields. When I print report
there are gaps btween row which is not acceptable. So how can I remove this
gap when there is no record ?

Andy
 
Back
Top