Hello all...my first post on this forum so go easy on me!
I'm trying to format a simple address string in a report such that the address lines appear only when necessary and on the correct lines. Is there a valid operator for a return character in a string? I've got 5 fields: Address1, Address2, City, State, Zip. I want to leave off the Address2 field if it is blank (i.e. suite number/floor), and I want city, state, zip to appear on a line by itself immediately after address1, or address2 as the case might be. I want to get all of this in a single text box control, because I'm running low on space on my report. Here's what I'm playing with in my text box:
Anyone have ideas on how to accomplish this? I can't seem to find any resources for complete lists of string concatenation operators...just knowing how to put a return in a string would be a massive help.