I have a report which is just a letter to say we have received your application. However to keep the address window small I have placed Address1 and Address2 on the same line seperated by a (,). The query to generate the report works fine but when you look at the report the spacing is all over the place. I have tried the Can Shrink and Can Grow options but all that does is strecth the cell vertically rather than horizontally.
Is it possible to do this or do I have to go back and either re-write my query joining the cells together or do it within the report.
The other question is how do you get it to rezise the cells beneath a row which is blank, i.e. shift up.
Is it possible to do this or do I have to go back and either re-write my query joining the cells together or do it within the report.
The other question is how do you get it to rezise the cells beneath a row which is blank, i.e. shift up.
