Not showing the & if no Foster Father is present

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

Guest

FosterHome: [Foster Home] & ", " & [Foster Mother] & " & " & [Foster Father]
& " " & [FH Address] & ", " & [FH City] & ", " & [FH State] &
", " & [FH Zip] & " " & [FH Phone]
 
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]
 
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?
 
Back
Top