#### in Access Pivot Tables

[sternb]

I have an Access 2007 pivot table and can't seem to get rid of the ### signs
showing instead of my values showing. I have widened the columns but am still
having problems. Help!

 

[Daryl S]

Sternb -

What should the data look like? (How big are the numbers?) And how many
#s do you see in the widened column?
You may want to format your data - are you showing both comma and decimal
separators as well as maybe a currency symbol and/or brackets for negative
values? They all take up room. Expand the column very wide until you get a
value you can see - maybe there is an error in a calculation or something
that is returning numbers much larger than you expect?

 

[sternb]

The numbers are formatted correctly and the pivot table looks fine until I
look at it in Print Preview. Then many of the numbers change to the ####
symbols and print with the #### symbols showing.

 

[George Hepworth]

You just might be running into a case where the size of the font , length of
the string, and the width of the "Cell" conspire to prevent display of the
entire value. When that happens, the result will be #### is displayed to
tell you "there is something here, but that it is too wide to print/display
in this particular mode."

The solution, obviously, is to give that cell more width so it can do its
job more gracefully.

HTH

George