Formatting a summary label

[cheyenne2002]

How can I tell the following code to capitalize the state if the user puts it into the database in lower case. I have the problem fixed on the input form, but I am not sure how to do it on the form. I have listed below the code that gives me the summary total.

="Summary for the state of " & [ST] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"


What do I need to do to get the two letter state to always be displayed in CAPS?

Thank you
Sam

 

[THWatson]

cheyenne2002
Have you tried UCase?

="Summary for the state of " & UCase([ST]) & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"

Tom

 

[Remou]

If you mean just the first letter,
StrConv ([ST], vbProperCase)
May suit

 

[cheyenne2002]

You are a dream THWatson. It worked.

Remou, I'm going to keep your code in my little black book for future use.

Thanks both of you.

Sam