Issue with form fields. Deadline: Can someone assist?

[cnut1]

I have a form that pulls data from a table. Basically the form is just a postcard. I have our company name, address, PO Box, city, state and zip in the upper left corner. My fields in the center of the postcard tie back to a table that contains the contact companies name, street address, PO Box, city, state and zip. My question is this: How do you format the contact company, address, PO Box, city, state and zip so that it appears uniform when printed? Some of the contact companies will have a street address but not a PO Box. How can I have the form print so the PO Box does not leave that field blank and pulls up the city, state and zip into that empty space? Also if one company's city is shorter than another how can it be formatted to pull over the state to make it uniform?

Any help on this would be greatly appreciated. I am under heavy deadline to have this form corrected and working by the end of the week.

Thanks in advance,
cnut1

Attempted to add the database but it would not upload for some reason. Will try again tomorrow. I am sure the way I am doing some things are not necessarily the best or easiest way since I am still learning Access. The form I am looking for help on is frmpostcardJanfrt.

 

[Rickster57]

I'm having a hard time visuallizing this. Can you attach a picture of what you are doing? I'm only on my first cup of coffee so forgive me.

 

[Sergeant]

Make a report. Use "can shrink" setting on the text boxes.
For the city, state, zip...you may want an unbound control with control source like this:
=[city] & ", " & [state] & " " & [zip]

 

[cnut1]

Sergeant

Thanks for the info Sergeant. Gave it a try and it seems to be working for me!