Concatenate and capitalization

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I'm trying to use the concatenate fuction in a report to
put the city, state and zip fields all in one line on a
report. I'm using this code...but I want to make sure the
State field is all caps all the time (I've used the '>'
in the forms and tables) and the > command in the code
doesn't work. Any thoughts?

=[city]& ", " & [state]& " " & [zip]

this doesn't work: =[city]& ", " & >[state]& " " & [zip]


Thanks
Eric
 
I'm trying to use the concatenate fuction in a report to
put the city, state and zip fields all in one line on a
report. I'm using this code...but I want to make sure the
State field is all caps all the time (I've used the '>'
in the forms and tables) and the > command in the code
doesn't work. Any thoughts?

=[city]& ", " & [state]& " " & [zip]

this doesn't work: =[city]& ", " & >[state]& " " & [zip]


Thanks
Eric
Click to expand...

=[city]& ", " & UCase([state]) & " " & [zip]
 
-----Original Message-----
I'm trying to use the concatenate fuction in a report to
put the city, state and zip fields all in one line on a
report. I'm using this code...but I want to make sure the
State field is all caps all the time (I've used the '>'
in the forms and tables) and the > command in the code
doesn't work. Any thoughts?

=[city]& ", " & [state]& " " & [zip]

this doesn't work: =[city]& ", " & >[state]& " " & [zip]


Thanks
Eric
Click to expand...

=[city]& ", " & UCase([state]) & " " & [zip]
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...

Thank you very much Fred...what a simple solution!
e
 
Back
Top