Changing the case of characters in a VBA or VFP string

VBA

UCase(), LCase(), StrConv()

VFP

Upper(), Lower(), Proper()

Notes

The straightforward case-conversion routines work in the same way in both languages. In VFP the Proper() function returns the string with the first letter capitalised. In VBA the StrConv() function with a parameter of 3 does the same.

Finding characters  |  Text functions  |  Changing characters

Access Tips

FoxPro Tips

General Tips

 

Related Items

VFP and VBA.

The Visual FoxPro and Visual Basic for Applications languages are similar but there are annoying differences between them.

Read More

Text delimiters in VBA and VFP.

Visual FoxPro and Visual Basic for Applications both use quotes to delimit strings but FoxPro has alternative methods.

Read More

Text concatenation in VBA and VFP

Concatenating text strings in Visual FoxPro and Visual Basic for Applications.

Read More

Text substrings in VBA and VFP

Both Visual FoxPro and Visual Basic for Applications let you extract substrings from within a string of text

Read More

Trimming text in VBA and VFP

Both Visual FoxPro and Visual Basic for Applications let you trim leading and trailing spaces from string of text

Read More