report formating

[dave]

hello
i m designing report with fields name, addressline1,addressline2,
suburb,state..

i want output sth like this

Mr. peter addressline1
addressline2
suburb,state

Mr.craig addressline1
addressline2
suburbu,state

Only the problem is i dont put blank line if some contact doesnt have
addressline2..
for example if mr. peter doesnt have addressline2 then out put should be

Mr. peter addressline1
suburb,state

Mr.craig addressline1
addressline2
suburbu,state

Is it possible...
Any help would be appreciated...
Thanx

 

[tina]

in report design view, set the "addressline2" control's CanShrink property
to Yes. also, set the CanShrink property to Yes for the report *section*
that the control is in.

hth

 

[Tony Williams]

Try changing "Can Shrink" property of the controls on the report to Yes
Tony

 

[dave]

I tried...
I have 'detail' section in report...
In the detail section fields are align sth like this...

[Name] [Addressline1]
[Addressline2]
[Suburb][State]

I set the CanShrink & CanGrow property to yes and also CanShrink property to
yes of detail section..
But still its not working...and putting blank line if Addressline2 is Null.

Thanx

 

[tina]

if there is one or more other controls on either side of [Addressline2] that
stretch vertically into that area, that will prevent the space from
shrinking. (hard to explain, sorry i can't do screen prints for you to
illustrate.) here's two examples:

[Name] [Addressline1]
[Addressline2] [AnotherControl]
[Suburb][State]

and

[Name] [Addressline1] [AnotherControl
[Addressline2] StretchesIntoArea]
[Suburb][State]

first, try setting the CanShrink property of *all* controls in the Detail
section to Yes. if that doesn't work, you'll need to adjust the
placement/sizing of controls adjacent to [Addressline2] to allow the space
to shrink.

hth

I tried...
I have 'detail' section in report...
In the detail section fields are align sth like this...

[Name] [Addressline1]
[Addressline2]
[Suburb][State]

I set the CanShrink & CanGrow property to yes and also CanShrink property to
yes of detail section..
But still its not working...and putting blank line if Addressline2 is Null.

Thanx

in report design view, set the "addressline2" control's CanShrink property
to Yes. also, set the CanShrink property to Yes for the report *section*
that the control is in.

hth