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).