Negative Number Format for Decimal or Double

[whdyck]

I'm using Access 2003.

In a form I have a textbox control that displays numbers in Standard format with three decimal places. I'd like to be able to display them with a negative number format (displaying parentheses rather than the negative sign): Unfortunately, I cannot seem to get it to display that way. I had thought that I could accomplish this by simply changing the Negative number format in my PC's regional settings (Control Panel), but that doesn't seem to work.

I have other textbox controls displaying numbers as Currency. If I set my PC's regional settings so that the Negative currency format is ($1.1), the controls display correctly in Access. However, with the controls that display numbers, not so. (They keep displaying them with negative sign rather than parentheses.)

Any idea where I'm going wrong?

Thanks for any help you can give.

Wayne

 

[bob fitz]

Try setting the Format property to

0;(0.000);;"0.0"

 

[whdyck]

Thanks! That worked.

I think I understand the first two parts of the format string (pos number format; neg number format). But what do the last two pieces represent (;;"0.0")?

Wayne

 

[bob fitz]

From the help file:

SectionDescriptionFirstThe format for positive numbers.SecondThe format for negative numbers.ThirdThe format for zero values.FourthThe format for Null values.

For example, you could use the following custom Currency format:
$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null" This number format contains four sections separated by semicolons and uses a different format for each section.

If I understand it correctly, they format for zero values and null values.