Not showing the & if no Foster Father is present

K

krc547

FosterHome: [Foster Home] & ", " & [Foster Mother] & " & " & [Foster Father]
& " " & [FH Address] & ", " & [FH City] & ", " & [FH State] &
", " & [FH Zip] & " " & [FH Phone]
 
O

Ofer Cohen

If you don't want the & to show if Foster Father field is empty, try to
change the & connection to +

FosterHome: [Foster Home] & ", " & [Foster Mother] & " & " + [Foster Father]
& " " & [FH Address] & ", " & [FH City] & ", " & [FH State] &
", " & [FH Zip] & " " & [FH Phone]
 
F

fredg

FosterHome: [Foster Home] & ", " & [Foster Mother] & " & " & [Foster Father]
& " " & [FH Address] & ", " & [FH City] & ", " & [FH State] &
", " & [FH Zip] & " " & [FH Phone]
Click to expand...

Use the + instead of & to concatenate the data within parenthesis:

[Foster Home] & ", " & [Foster Mother] & (" & " + [Foster Father]) &
...... etc.

Why in the world do you wish to show all this data on one line instead
of 4 or more?
 
Top