Instead of making a choice from the list, type in your own
format code
the format property
on format code -- there are 4 parts
1. format for positive numbers
2. format for negative numbers
3. format for 0 (zero)
4. format for null
parts 2 thru 4 are optional
Format --> #,##0.00;[red]-#,##0.00;0.00;0.00
show commas between thousands, always show the ones place
and 2 decimal places -- even if the number is null.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9910
Negative numbers are red
Format --> #,##0
show commas between thousands, no decimal places, always
show zero
Format --> #,###
show commas between thousands, no decimal places, don't show
anything if the number is zero
Format --> $ #,##0.00
show commas between thousands, always show the ones place
and 2 decimal places. Display a dollar sign.
****
for more help on Format, press the F1 key in that property
on the property sheet (if you are in a query, you may not
get help -- press F1 in the Format property of a control on
a form or report
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9910
Warm Regards,
Crystal
Microsoft Access MVP 2006
*
Have an awesome day
remote programming and training
strive4peace2006 at yahoo.com
*
pomeroymiles@gmail.com wrote:
> I have a pivotchart which I cause to take a huge list of people's test
> percentiles and calculate the average for each year. I then display the
> average above each bar. The problem is that there are too many numbers
> after the decimal place for each figure. I went into the properties and
> changed the number format to "fixed" but it doesn't give me the option
> to change the number of decimal places that are used (it does every
> where else in MS Office!). It seems that it just uses the regional
> settings for the computer. But the problem I have in changing that is
> that I have other pivotcharts in the same report that does something
> similar but needs a different number of decimal places. Is there any
> way around this without having to create another query to calculate the
> average and then having the pivotchart display the info from the new
> query (this is a huge database that I put together with many charts and
> I don't want to have to redo the way that it works just because of this
> decimal place issue)?
> 
Our Donation Goal
: Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters 
Linear Mode
