Visual Basic and Visual FoxPro functions to format text

VBA

Format()

VFP

Transform()

Common Syntax Notes

These functions offer a bewildering amount of choice. Both languages let you apply different formats to numbers, text and dates. Read Help for the full details.

Repeating characters | Text functions | Converting text

VFP and VBA.

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

Text delimiters in VBA and VFP.

Visual Basic for Applications and Visual FoxPro delimiters for strings.

Text concatenation in VBA and VFP

Visual Basic for Applications and Visual FoxPro operators to concatenate text.

Text substrings in VBA and VFP

Visual Basic for Applications and Visual FoxPro functions to extract substrings from within a string of text

Trimming text in VBA and VFP

Visual Basic for Applications and Visual FoxPro functions to trim leading and trailing spaces from string of text

Visual Basic and Visual FoxPro functions to format text

VBA

VFP

Common Syntax Notes

VFP and VBA.

Text delimiters in VBA and VFP.

Text concatenation in VBA and VFP

Text substrings in VBA and VFP

Trimming text in VBA and VFP

September 2010

Database development and training for Birmingham and the midlands

Specialists in Microsoft Access and Visual Foxpro training and development

Phone us on 0121 445 1300, email sales@alvechurchdata.co.uk , or use our contact page