crosstab column field size

[Guest]

I'm having a problem getting my crosstab to recognize the entire string for
its column heading, which cuts off the string at a certain point.

This is not good since some strings are essentially identical until the very
end. As such, the column in the crosstab (which is displayed in a subform)
reads only up to a point, then displays 'field0', 'field1', etc. for similar
columns.

The sql criteria shows the full string, and the full string appears in the
query the crosstab searchs for similar strings. It just wont read the whole
thing for its search.

Is there a way to change the length of the field in a crosstab, ie) from 50
character text to Memo? Is this even what I need to do?

Thanks

 

[Duane Hookom]

I can't imagine that long of a generated column heading. You are limited to
64 characters in field/column names.

 

[Guest]

well if I'm limited, I'm limited....I'll just pivot date instead of item.
Thanks.