Report

[Linn2tigger \(remove this\)]

I design a table, query, form and report.
I have Ship To, Address 1, Address 2, City, State,Zip Code
fields If I do not put any data in Address 2 in the form,
when I go to report to print there is a blank space
between Address 1 and City. How do I get Address 2 not to
leave a blank space if there is no data typed in?

 

[fredg]

I design a table, query, form and report.
I have Ship To, Address 1, Address 2, City, State,Zip Code
fields If I do not put any data in Address 2 in the form,
when I go to report to print there is a blank space
between Address 1 and City. How do I get Address 2 not to
leave a blank space if there is no data typed in?

Set the control's CanShrink property to Yes.
Also set the Detail section's CanShrink property to yes.
There can be no other control on that same line.

 

[Guest]

-----Original Message-----


Set the control's CanShrink property to Yes.
Also set the Detail section's CanShrink property to yes.
There can be no other control on that same line.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Thank you, it worked.