suppressing blank fields in addresses

[Stuart Green]

I am using Access to produce letters. There are 5 address fields and 1 for postcode/zip code. Not all of my records have data in all the 5 address fields but all have a post code. In these cases the address on the letter has a gap between the address and the post code which I would like to be suppressed (ie the post code move up). I have tried setting the properties of each field to can shrink thinking this might do it but no joy. I have tried searching the forum but can't find anything. Any way this obvious problem should be tackled please as it doesn't look very professional on the letters

 

[Rich]

=[Address1]& Chr(13) & Chr(10) & [Address2] etc

 

[Stuart Green]

sorry rich could you...er..expand a bit on the posting please.

 

[Stuart Green]

I had tried creating one unbound field on the report carrying the following but I still get the blank lines

=[address1] & Chr(13) & Chr(10) & [address2] & Chr(13) & Chr(10) & [address3] & Chr(13) & Chr(10) & [address4] & Chr(13) & Chr(10) & [address5] & Chr(13) & Chr(10) & [post_code]

 

[simongallop]

According to the Label Wizard, by setting the Can Shrink and Can Grow properties to YES it ought to work.

Make sure that the fields which are blank are truly blank ie Null rather than having a space or such like

HTH

 

[Stuart Green]

Well, I've checked and they are blank, got no data in them at all but still no joy even with field properties on the report set to can shrink and grow

 

[Marilor]

try this..

I don't know if this will help, but do you have the Can Shrink, Can Grow set to YES in the Detail Properties also??

Just an idea.

Maria

 

[Stuart Green]

Thank you all very much for your help. I finally tracked the problem down to my having a letter date field on the letter on the right of the letter but in line with one of the address fields that may be blank. So, of course it couldn't shrink. Will just have to redesign my letter so that no contact name, reference or letter date fields appear onthe same line as the address to get it to work