Format portion of text sting in upper case

  • Thread starter Thread starter Sammie
  • Start date Start date
S

Sammie

I have a concatenated string in my query like
=([field1] & [field2] & [field3])
I want field2 to appear in upper case, but the rest of the fields are to be
normal case, as they were typed in. I formatted field2 in my query as upper
in the format property with ">" but the upper case is lost within my string.
Any ideas?
 
Sammie said:
I have a concatenated string in my query like
=([field1] & [field2] & [field3])
I want field2 to appear in upper case, but the rest of the fields are to
be
normal case, as they were typed in. I formatted field2 in my query as
upper
in the format property with ">" but the upper case is lost within my
string.
Any ideas?
Click to expand...

Use the Ucase function:

=([field1] & Ucase([field2]) & [field3])
 
Back
Top