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?

& 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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIf issue 3
Putting text in parentheses 2
Recordset/recordsource clarification 2
Query Help 3
Looping Help Please 5
Value look up 1
Need help generating a report 2
Calculate between SubReport and Report 1

Back
Top