How to string 4 text field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with names and 4 fileds for the phisical address and 4
fields for the postal address. Some of the address fields may be empty or
not. I want to create a report with the phisical and postal adress side by
side, where the address 'floats' and does'nt show the empty fields. Like
this:

Joe Doe 123 Street Name PO Box 7890
Urb. Good View City-Name, ST 12345
City-Name, ST 12345

Jane Smith 456 Street-Name
City-Name, ST 23456
 
In the record source query for your report you can create new fields for the
physical address and the postal address. Use these as the "control source"
for two text boxes you will place side by side on your report.

First the physiclal address field:
phyAddress:[name] & chr(13) & [phyAddress1] & chr(13) & [city] & ", " &
[phyState] & " " & [phyzip]

The postal address will be something like this:
postAddress:[name] & chr(13) & [postAddress1] & chr(13) & [city] & ", " &
[postState] & " " & [postzip]

Note: chr(13) moves to the next line.

I hope this helps
 
Back
Top