Address format in report (1 Viewer)

[Lily]

Would there be a solution to this...when I set up my form I made three address fields, Add 1, Add 2, Add 3, then City, etc., each being a separate field. If the address is long, I use all 3 fields. If a short address it may only use Field 1...then I tab to city, etc. When I produce labels, it omits the blank fields and runs the address together. However, when I put the address test boxes like that in a repport, it does not omit the blank fields, therefore, it leaves spaces before it prints the city, etc. I tried to copy the =Trim expression from the label design view, but it did not eliminate the blank spaces on the report address, however, it did realign City, State, Zip...based on the expression used in Label Wizard. Is there a way to get it to omit the blank fields and run address consecutively in a report? Thanks very much for all your help. It is much appreciated.

 

[Rich@ITTC]

Hi Liily

You could set the Can Shrink property for each of the text boxes to True and also set the Can Shrink property for the Detail to true.

HTH

Rich

 

[Jack Cowley]

Lily -

This article will show you how to create some code and along with the CanShrink property will do what you want. I use this in all of my programs as it works very well....
http://support.microsoft.com/support/kb/articles/Q95/3/90.ASP?LN=EN-US&SD=gn&FR=0

HTH,
Jack

 

[Rich@ITTC]

Hi Lily

Thanks for your e-mail. Usually we try to continue the correspondence via the Access World Forum (in case others want to follow the thread).

Try setting to Yes for Can Shrink (sorry that I suggested True before, but I was doing it from memory).

HTH

Rich