Pivot Legend only shows first two letters of the word

[Bar_NZ]

Hey there, can someone help me please, I have a query that pulls information from a combo box in my form, now I've made a pivot form to report the outputs, however my legend will only display the first two letters of word... I need to show the entire word, any ideas??? :banghead:

 

[namliam]

are you by chance only showing the bound column, instead of the looked up value?

 

[Bar_NZ]

Yes I think I am, how do I change which column it looks at??

 

[namliam]

You dont, you join the lookup table and build the crosstab on the proper column instead of the bound column