Pivot Table Dropdown


Posted by Brian on September 27, 2001 9:02 AM

Is there a way to change the font size and/or properties of a Pivot Table Page Field dropdown? In other words, when you click on the dropdown arrow - it displays a list and I have my column sized fairly small so I can't read all of the data.

I suppose I could figure out a way to put in a quick event procedure to make the column wider when I click and then restore to smaller after selecting.

any ideas
Thanks

Posted by Mark W. on September 27, 2001 11:42 AM

Why not apply a custom format that will insure
a minimal column width? For example, the format,
"@ " (without the quotes) will insure a
column width that will minimally display 8 spaces
for text page items. Let's assume that your
page items are {"cat";"dog";"lepard";"elephant"}
the above format will insure that your drop down
list won't be "cropped" even if "cat" is your
selected page item.



Posted by Mark W. on September 27, 2001 11:44 AM

Please note...

...that this bulletin board supresses duplicate
space characters. The format specified below is
"@bbbbbbbb" where "b" is a space character.