uppercase format

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

Guest

I have the following expression in a report:
=IIf(IsNull([Incumbent First]),"VACANT",[Incumbent First]) & " " & IIf(Not
(IsNull([MI])),[MI] & ". ") & [Incumbent Last]

How do I make just the [MI] come out as uppercase?
 
I think it is "ucase"...

=IIf(IsNull([Incumbent First]),"VACANT",[Incumbent First]) & " " & IIf(Not
(IsNull([MI])),UCase([MI]) & ". ") & [Incumbent Last]
 
I have the following expression in a report:
=IIf(IsNull([Incumbent First]),"VACANT",[Incumbent First]) & " " & IIf(Not
(IsNull([MI])),[MI] & ". ") & [Incumbent Last]

How do I make just the [MI] come out as uppercase?
Click to expand...

& IIf(Not IsNull([MI]),UCase([MI]) & ".") & etc

Note: Watch your parentheis. You don't need the open parenthesis
between Not and IsNull, therefore you also don't need that extra
closing parenthesis after IsNull([MI])
 
Back
Top