Format

  • Thread starter Thread starter Dorian Chalom
  • Start date Start date
D

Dorian Chalom

Can some one please explain how i can use the format property to display
numbers and/or currency and if the value is zero (0) to print nothing at
all?

TIA

DC
 
Dorian Chalom said:
Can some one please explain how i can use the format property to display
numbers and/or currency and if the value is zero (0) to print nothing at
all?
Click to expand...

From Access 97 Help file
*******************

Custom Formats

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 The format for positive numbers.
Second The format for negative numbers.
Third The format for zero values.
Fourth The format for Null values.

For example, you could use the following custom Currency format:

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"
 
But will this limit the value to 99,999.99 through (99,999.99)
or will it handle 9,999,999.99 through
(9,999,999.99)
or do I need make the expresion $9,999,999.99 through ($9,999.999.99)
to handle values $9,999,999.99 through
($9,999,999.99)?



Rick Brandt said:
Dorian Chalom said:
Can some one please explain how i can use the format property to display
numbers and/or currency and if the value is zero (0) to print nothing at
all?
Click to expand...

From Access 97 Help file
*******************

Custom Formats

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 The format for positive numbers.
Second The format for negative numbers.
Third The format for zero values.
Fourth The format for Null values.

For example, you could use the following custom Currency format:

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"
Click to expand...
 
Dorian,
In the Format property of the control, write
#,###.00;-#,###.00

The values will print with a comma separation for each 3 digits, the
negative numbers will display a minus sign, and nothing will appear if the
value is 0.
This information is available to you in Access help. Click your cursor in
the controls Format property and press F1. Then select the Number and
Currency datatype type link.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Dorian Chalom said:
But will this limit the value to 99,999.99 through (99,999.99)
or will it handle 9,999,999.99 through
(9,999,999.99)
or do I need make the expresion $9,999,999.99 through ($9,999.999.99)
to handle values $9,999,999.99 through
($9,999,999.99)?



Rick Brandt said:
From Access 97 Help file
*******************

Custom Formats

Custom number formats can have one to four sections with semicolons (;)
Click to expand...
as
the list
separator. Each section contains the format specification for a
Click to expand...
different
type of
number.

Section Description
First The format for positive numbers.
Second The format for negative numbers.
Third The format for zero values.
Fourth The format for Null values.

For example, you could use the following custom Currency format:

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"
Click to expand...
Click to expand...
 
Dorian Chalom said:
But will this limit the value to 99,999.99 through (99,999.99)
or will it handle 9,999,999.99 through
(9,999,999.99)
or do I need make the expresion $9,999,999.99 through ($9,999.999.99)
to handle values $9,999,999.99 through
($9,999,999.99)?
Click to expand...


I don't believe that the example from help will place any limitations on the
data at all. And I was not suggesting that that particular example would solve
your problem. I was assuming that given an example like that you could
determine what sort of format you could use to handle zeros.
 
Back
Top