Page History: Format Property - Microsoft Access

Compare Page Revisions

2 1 0 Current 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Mon, Sep 19, 2011, 9:03 AM

In Microsoft Access, custom number formats can have one to four sections with semicolons (;) as the list separator. Each section contains the format specification for a different type of number.

Section	Description
First	Positive Numbers
Second	Negative Numbers
Third	Zero
Fourth	Nulls

Example

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"