Free E-Books

You create custom formats by composing a string made up of one to four sections separated by
semicolons. Each section has a different meaning to Access:
n First section: The format specifier for positive values.
58
Access Building Blocks Part I
n Second section: The format specifier for negative values.
n Third section: The format specifier for zero (0) values.
n Fourth section: The format specifier for null values.
Each section is a combination of a numeric formatting string and an optional color specification.
Here??™s an example of a custom format:
0,000.00[Green];(0,000.00)[Red];???Zero???;??? ??” ???
This format specifies showing the number with zeros in all positions (even if the number is less
than 1,000), using the comma thousands separator, enclosing negative numbers in parentheses,
using three pound signs to indicate a zero value, and using three dashes for null values.
Date/Time field formats
Access includes a wide variety of built-in and custom formats applicable to Date/Time fields.


Pages:
257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281