Blank lines in my report

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

I am trying print a report with an address in the top
corner. It puts in the blank lines where there is no data
how do i get them out

Instead of dragging each feld how do I put them in one
Text box and pu Carriage returns in the rigt place

I have set all prpoerty to Can Shrink

Cheers Joel
 
Try the Trim() function on the fields. Leave the SetShrink to true on both
the field, and the grouping level (if you want the whole grouping level to
shrink).

// Dave
 
I am trying print a report with an address in the top
corner. It puts in the blank lines where there is no data
how do i get them out

Instead of dragging each feld how do I put them in one
Text box and pu Carriage returns in the rigt place

I have set all prpoerty to Can Shrink

Cheers Joel
Click to expand...

Adapt this to your needs.

=(Name1] & (chr(13) + Chr(10) + [Name2]) & (chr(13) +
Chr(10) + [address1]) & (chr(13) + Chr(10) + [address2]) &
[City] & ", " & [State] & " " & [Zip]

Use the + and & () as indicated above.
If any one of the fields is blank the line space will not occur.
 
I have trieed what was suggested but I get an error
message. I put the text in Control source right of the
text box please help driving me mad
-----Original Message-----
I am trying print a report with an address in the top
corner. It puts in the blank lines where there is no data
how do i get them out

Instead of dragging each feld how do I put them in one
Text box and pu Carriage returns in the rigt place

I have set all prpoerty to Can Shrink

Cheers Joel
Click to expand...

Adapt this to your needs.

=(Name1] & (chr(13) + Chr(10) + [Name2]) & (chr(13) +
Chr(10) + [address1]) & (chr(13) + Chr(10) + [address2]) &
[City] & ", " & [State] & " " & [Zip]

Use the + and & () as indicated above.
If any one of the fields is blank the line space will not occur.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top