I'm using access to print a letter to patrons. Not all of them have a company they are associated with so I have the following unbound text box which will print a company if there is one, but not leave a blank space if there is not:
=([First_Name]+" ") & ([Last_Name]+" ") & ([Company]+" ") & [Street] & [City] & ", " & [State] & " " & IIf(Len([zip])=5,Format([zip],"00000"),Format([zip],"00000-0000"))
My problem is that it prints everything out on one continuous line and I want to add in line breaks to split it up.
Can this be done? I've tried messing around with "vbcrlf" which I found searching on here, but I can't make it work.
I can resort to putting everything on its own line but then if there is no company for that person there will be a blank line between their name and address which would look stupid.