If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I have report fields stored as total caps display in Prope.
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. |
#2
|
|||
|
|||
How do I have report fields stored as total caps display in Prope.
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 '================================================= === BillS wrote: 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. |
Thread Tools | |
Display Modes | |
|
|