Null Math

I normaly make my address block as name, line1, line2, city, st, zip.  not suer what STE is thinking that may fit in line2.  kinda looks like this

NameLast, Name First
123 Main Street
ste 100
Cape Canab, FL 10109  

Anyways the null math will spark ideas as to how to work with kind of problems.

Hi Ryan, By Setting up your table as Juan suggested, it is quite easy to concatenate the information for any report or label. It is easier to concatenate than to split the data apart later. You can set up as many lines as needed in the table.  HTH John

I also create an address block made up of concaternated fields. As Juan suggested, I store individual fields for line1, line2, line3, city, state, zip+4.  I would also recommend that the postal fields adher to USPS postal addressing standards USPS Publication 28
( https://pe.usps.com/text/pub28/28c1_001.htm#ep275126 ).  This is a good practice for address maintenance that avoids a lot of headaches later on with address maintenance. And makes for more accurate domestic mail delivery.  Oh, and by the way, STE is the official abbreviation for Suite, which should come directly after the street address, ex. 123 Main St Ste 100 !

Ryan, just note that the next to the last line should have the address (either the street address or the p o box address) to be used as the primary delivery address.  This line should correspond to the last line with city, state & zip+4 for delivery.  The  postal services iMB scanners read from bottom up to obtain the city, state & zip information.  
In your example:
Building Name
123 MAIN ST STE 100
PO Box 123
Anycity, AC  99999-0123

I live in a place where the government likes to split addresses down to some microscopic "atomic" level. So, I allow for both: address lines and "atomic" level data. I also allow which lines to include in a label, because some places, like previous Costa Rica addresses (North basketball court, 2nd street toward mountains, green house with red door on right), and many current ones in Africa and the Middle East include notational data. Also, the standard city, state, zip format doesn't work in most countries. Not all countries like all upper case. Ireland can drive you nuts trying to figure out how to implement their postal code system.

Thanks everyone.  Very helpful.