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

More tips from Alvechurch Data

More tips from Alvechurch Data

Address formats

Storing addresses in a consistent format.

Read More

American dates in Access SQL

Microsoft Access databases use an American date format in SQL commands.

Read More

FoxPro file extensions

File formats and extensions used by FoxPro

Read More