| | |
|
|
|
Blank lines in report |
|---|
| message from =?Utf-8?B?R29yZG9u?= on 29 May 2004 |
I have a question I hope you can answer. I have produced a invoice report which incorporated the customers names and addresses. However some of the data in the field on the table are emply and this of course is coming out as a blank line in my report
The fields I have at present read like this:-
=[First name &] " " & [Last name]
Address 1
Address 2
Address 3
Town
Postal code
I hope you can help
Regards
Gordon
|
| MyndPhlyp replied to =?Utf-8?B?R29yZG9u?= on 29 May 2004 |
which incorporated the customers names and addresses. However some of the
data in the field on the table are emply and this of course is coming out as
a blank line in my report
How about changing to a single text box, setting the CanShrink/CanGrow, and
then take advantage of the "+" operator propagating Nulls making the
contents read something like:
([Address1]+Chr$(13)+Chr$(10)) & _
([Address2]+Chr$(13)+Chr$(10)) & _
([POBox]+Chr$(13)+Chr$(10)) & _
(([City]+", ") & ([StateProvince]+" ") & [ZipPostalCode]+Chr$(13)+Chr$(10))
& _
([Country])
It not only eliminates extra lines, it also eliminates unnecessary
punctuation within the parenthesis.
If Address1 is Null, the result of the formula between "(" and ")" results
in Null. Since Nulls don't print, and no CRLF was added because Address1 was
Null (propagation), the line is eliminated from output. Go through the same
routine for the remainder of the formula.
(Example stolen in its entirety from Page 135 of "Access Cookbook" published
by O'Reilly, authored by Getz, Litwin & Baron. All rights reserved. All
wrongs reversed. Tax, tags, title, destination, dealer prep and other
charges apply. Not available in all locations. Your mileage may vary.)
|
|
Archived message: Blank lines in report (Microsoft Access Forms)
