Prev: Updating Table with a form
Next: Quit macro not working in runtime
From: sternb on 17 May 2010 18:35
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!
--
sternb
From: Daryl S on 18 May 2010 12:13
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?

--
Daryl S


"sternb" wrote:

> 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!
> --
> sternb
From: sternb on 3 Jun 2010 14:20
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.
--
sternb


"Daryl S" wrote:

> 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?
>
> --
> Daryl S
>
>
> "sternb" wrote:
>
> > 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!
> > --
> > sternb
From: George Hepworth on 4 Jun 2010 15:15
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

"sternb" <sternb(a)discussions.microsoft.com> wrote in message
news:DA36095C-4518-49D3-9499-890B45B928ED(a)microsoft.com...
> 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.
> --
> sternb
>
>
> "Daryl S" wrote:
>
>> 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?
>>
>> --
>> Daryl S
>>
>>
>> "sternb" wrote:
>>
>> > 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!
>> > --
>> > sternb

 | 
Pages: 1
Prev: Updating Table with a form
Next: Quit macro not working in runtime