Format Function — Different Formats for Different String Values

Description

A format expression for strings can have one section or two sections separated by a semicolon (;).

If you use

The result is

One section only

The format applies to all string data.

Two sections

The first section applies to string data, the second to Null values and zero-length strings (" ").


See Also

Format function, Format function — different formats for different numeric values.

Specifics (Microsoft Access)

See the Format property specifics (Microsoft Access).