Formatting Names 1

[MisterC]

I'm trying to concatenate Last name, First Name, & Middle Initial.
Like: [LName], [FName], [MI].
...but I don't want the period after [MI] to show if there is no [MI].
This is what I have:
=[LName] & ", " & [FName] & " " & [MI] & "."

Isn't there an easy way to specify the "." is optional if [MI] is null? (Without using iif([MI]="","","."))

Thanks!

 

[RoyVidar]

Hi!

Try:

[tt]=[LName] & ", " & [FName] & " " [highlight cyan]+[/highlight] [MI] [highlight cyan]+[/highlight] "."[/tt]

Roy-Vidar

 

[MisterC]

Thanks RoyVidar, that did the trick.
Can you explain exactly how the + functions?

 

[RoyVidar]

No, not really;-)

Just picked it up here some time ago, and am rather happy for reducing the amount of code on my reports.

Would be enough with only the last one though. It seems when a control is null, there's some arithmetic causing the next control/expression/value not to display (Null + "Something" -> Null, whilst Null & "Something" -> "Something")

Roy-Vidar

 

[MisterC]

Makes sense to me. Thanks!