pivottable field name length limited to 23 characters?

M

Mike

I've just struck this one - I guess I can work around it
but it seems really odd. Looks like a bug. Anyone else
struck this limit?

I am referring to a PivotTable Fieldset by name. Field
names (and therefore FieldSet names) longer than 23
characters are being truncated ! So I get subscript out
of range errors.

The specific reference in my code is:
frmPivot.PivotTable.ActiveView.FieldSets
("Current_Liabilities_Amount")

The locals window shows that the Field (and therefore the
FieldSet) name has been truncated to
Current_Liabilities_Am (23 characters!?!). Fields on
other forms experience the same problem - they are
truncated at 23 characters.

Devt environment is Access 2002 SP2, ADP project with
code building a PivotTable view of a form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Field name length restricted to 8 characters? 5
Limit Memo field to 1500 Characters? 3
Filename length in Excel limited to 92 characters 3
Top n query using Allen Browne's "ConcatRelated" 5
The Search Key was not found in any record... 0
Running VB Code 3
MSACCESS 97 APPLICATION ERROR CONVERTING FROM TEXT TO MEMO 4
importing more than 65536 rows from .csv file 1

Top