I have this in a text Box under Control Source:
=[FullName] & "," & " " & [DProSuffix]
This is a MS Access Report done in 2010
So I what the "," if there is more data to place on the report.
Mr. John Smith, Professor
But I don't want the "," (Comma) to display if no more data and currently it would show:
Mr. John Smith,
Mr. John Smith
Thanks for any help...