Fmt Function

Formats data for output.

Syntax

Fmt (string, format)

string is the string to be formatted. If string is a null value, null is returned.

format is an expression that defines how the string is to be formatted. If format is null, the Fmt function fails. For detailed syntax, see Format Expression.

Remarks

The format expression provides a pattern for formatting the string. You can specify:

• The length of the output field
• A fill character to pad the field
• Whether the field is right-justified or left-justified
• A numerical, monetary, or date format
• A mask to act as a template for the field