Multiple lines w/o Spaces

[Aurora]

I am using Access 2000

I created a Db with a 8 fields of address infor;
CoName,
AttnName,
Add1,
Add2,
City,State,Zip,
Country.

In my report I can make it so that the City, State and Zip
appear on one line as they should. But don't know how to
do this the balance of the address so that it appears like
it does above, even if a field does not contain any
information. I do not want any blank lines in the address
area. Can anyone help me?

Aurora

 

[Gina Whipp]

Each field has to be set Can Shrink and Can Grow to Yes and the section of
the report has to be set Can Shrink and Can Grow to yes, that should
suppress blank lines.

 

[Jason]

An easy way to do it is just to fill the report from
code. Go down the list of items (Company name, Att,) and
fill in the textboxs in order with the available
information.