Using & and expression and Capitalization

  • Thread starter Thread starter epcurry
  • Start date Start date
E

epcurry

I am concatenating a few fields into one on a report, but I can't ge
the ">" capitalize command to work in the "State" field.
Here is my expression:
=[city]& ", " & [state] & " " & [zip]

I want it to come out to be "Denver, CO 80204"

When I enter into the form, I capitalize the Denver, so that's no bi
deal and I use the ">" in the form to change "co" to "CO", but how do
do it in the report expression? I've tried putting that darn ">
everywhere, but I still get errors.
thanks
Eri
 
epcurry said:
I am concatenating a few fields into one on a report, but I can't get
the ">" capitalize command to work in the "State" field.
Here is my expression:
=[city]& ", " & [state] & " " & [zip]

I want it to come out to be "Denver, CO 80204"

When I enter into the form, I capitalize the Denver, so that's no big
deal and I use the ">" in the form to change "co" to "CO", but how do I
do it in the report expression?
Click to expand...


A Format property applies to the entire contents of the
control.

You can use function for capitalizing a part of the string:

=[city] & ", " & UCase([state]) & " " & [zip]
 
Back
Top