Do not print blank fields

[Graham Bucknall]

I have some reports that gather address data from a query. Some fieldds are blank (eg add4 and add5). How can I set up the report so that it doesn't leave blank line where there are blank fields?

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43756

 

[Graham Bucknall]

That's fine but I'm not sure I understand the syntax and am not sure about your CHR(13) etc.
If I have field add1, add2, add3,add4, city,zip where 2,3 and 4 are frequently blank, how would I produce the concatenation? Also, would this be in the query?

 

[KevinM]

Here's a MUCH better way......

http://support.microsoft.com/default.aspx?scid=kb;en-us;95390

 

[Rich]

"Here's a MUCH better way...... "
matter of opinion surely?

 

[KevinM]

Yes, IMO it's a MUCH better way.

Had the same problem Grham had many years ago then discovered the article I posted in the A97 KB.

Used it ever since.

Mainly use it for labels/