removing unused spaces when printing

[Judy Bornstein]

How can I put two fields together and have them print side by side or top to bottom and take out unnecessary space between the fields? Thanks. Judy

 

[Rich]

=[Field1]&[Field2] or[Field1]&" "&[Field2]
HTH

 

[kdevitt]

I think you might want to throw a trim statement in there as well--

trim([Field1]) & " " & trim([Field2])

Ken