How do I have report fields stored as total caps display in Prope.

  • Thread starter Thread starter BillS
  • Start date Start date
B

BillS

In older versions of MS Access there was a function PCase() that would
capitalize the first letter of each word and lower case all others. This
appears to have been changed to something else as I still see UCase() and
LCase() on the list but no PCase().

ex. "EVERY GOOD DOG" as well as "every good dog" should show up on the
report as "Every Good Dog"

This should be relatively ease however it is currently stumping me.
 
You are looking for the StrConv function.
StrConv("every good dog",3)
will return Every Good Dog

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top