Uppercase

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Access form works off a parameter query for the report month. The header
field is formattted mmmm yyyy - ie. March 2005. I would prefer to have it
print in Uppercase. How can I force it to do so?
 
You can set the control source to:
=UCase(Format([YourField],"mmmm yyyy"))
Make sure the name of the control is not a field name.
 
That's my problem, I believe. It is a field bound to the actual expenditure
month. Is there any way to make this happen without going back and changing
the table data format from the past 10 years? I was able to set the format
property in the query and it worked on a new table - so I would have to
change everything in my table. Any suggestions?

By the way, thanks for helping out. :)
 
What is an "actual expenditure month"?

--
Duane Hookom
MS Access MVP


tex2pennlady said:
That's my problem, I believe. It is a field bound to the actual
expenditure
month. Is there any way to make this happen without going back and
changing
the table data format from the past 10 years? I was able to set the
format
property in the query and it worked on a new table - so I would have to
change everything in my table. Any suggestions?

By the way, thanks for helping out. :)

fredg via AccessMonster.com said:
In an unbound text control:
=UCASE(Format([FieldName],"mmmm yyyy"))
Click to expand...
Click to expand...
 
My reports accumulate expenditures for prior fiscal periods. The actual
expenditure month is when the $ posted versus when the service occurred.
Payment period vs. service period. Not that it matters... but thanks for the
chuckle!

Duane Hookom said:
What is an "actual expenditure month"?

--
Duane Hookom
MS Access MVP


tex2pennlady said:
That's my problem, I believe. It is a field bound to the actual
expenditure
month. Is there any way to make this happen without going back and
changing
the table data format from the past 10 years? I was able to set the
format
property in the query and it worked on a new table - so I would have to
change everything in my table. Any suggestions?

By the way, thanks for helping out. :)

fredg via AccessMonster.com said:
In an unbound text control:
=UCASE(Format([FieldName],"mmmm yyyy"))
Click to expand...
Click to expand...
Click to expand...
 
Back
Top