Database development and training for Birmingham and the midlands
Specialists in Microsoft Access and Visual Foxpro database training and development
I am happy to hear from existing clients but I am taking no new calls.
Visual Basic and Visual FoxPro functions to change the case of text
VBAUCase(), LCase(), StrConv()
VFPUpper(), Lower(), Proper()
Common Syntax Notes
The straightforward case-conversion routines work in the same way in both languages. In Visual FoxPro the Proper() function returns the string with the first letter of each word capitalised. In VBA the StrConv() function with a parameter of 3 does the same.
Note that neither of these last two functions are as useful as they might seem. You cannot use them to tidy up the poor capitalisation of a list of names because they blindly capitalise the first letter of each word. For example:
will give you "Mccartney" and you'll get similarly unhelpful results from "DICAPRIO" and "IBM".