Forcing text to upper case

[Ronald]

I recall reading that you can force text values in reports
to UPPERCASE... however I do not remember how.

Any assistance would greatly be appreciated.


Ronald

 

[Ronald]

Thank you for the assistance

 

[Dirk Goldgar]

If you want to do it in a query, then you need to write a function
like the one below:

Function Upper(P_String_Value)
Upper = Format(P_String_Value, vbUpperCase)
End Function

Then you can call that function from your query:

UpperCaseValue: Upper([YourField])

I recall reading that you can force text values in reports
to UPPERCASE... however I do not remember how.

Any assistance would greatly be appreciated.

Lynn -

I think you meant to use the StrConv() function instead of the Format()
function. But why not just use

UpperCaseValue: StrConv([YourField], 1)

in the query?

 

[Lynn Trapp]

I think I'm half asleep today, Dirk. You're quite right, but it was fun
writing my own function... <g>

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

If you want to do it in a query, then you need to write a function
like the one below:

Function Upper(P_String_Value)
Upper = Format(P_String_Value, vbUpperCase)
End Function

Then you can call that function from your query:

UpperCaseValue: Upper([YourField])

I recall reading that you can force text values in reports
to UPPERCASE... however I do not remember how.

Any assistance would greatly be appreciated.

Lynn -

I think you meant to use the StrConv() function instead of the Format()
function. But why not just use

UpperCaseValue: StrConv([YourField], 1)

in the query?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)