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.
