Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Page History: Format Property - Microsoft Access

Compare Page Revisions



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

SectionDescription
FirstPositive Numbers
SecondNegative Numbers
ThirdZero
FourthNulls

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

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2020, Patrick Jasinski.