Max length of Column Heading in Crosstab

[Tim Johnson]

Hi there,

I have written a crosstab that uses a concatenation of 3 fields for the
column heading ([StoreName] & " " & [Address] & " " & [City]), but after
55-60 characters long, the query is truncating the column heading...what is
the max size I can use here, or am I doing something incorrectly?

Thanks,
Tim

 

[John Spencer]

I believe that maximum size is 64 characters. I could be wrong. I often am
wrong.

IN my opinion, a column heading that long is suspect anyway.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Tim Johnson]

You may be right (and I would guess you often are, contrary to your statement
...).

I agree with your opinion in general about the column heading length, but I
am trying to output a comparison report to Excel and this seemed the easiest
method by which to denote which dataset's results were listed and let the
user know exactly what they are looking at.

I may have to do some truncation/abbreviation myself, or just exclude a
street address altogether.

I believe that maximum size is 64 characters. I could be wrong. I often am
wrong.

IN my opinion, a column heading that long is suspect anyway.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Hi there,

I have written a crosstab that uses a concatenation of 3 fields for the
column heading ([StoreName] & " " & [Address] & " " & [City]), but after
55-60 characters long, the query is truncating the column heading...what is
the max size I can use here, or am I doing something incorrectly?

Thanks,
Tim

 

[Mark Andrews]

You could switch to excel automation and use a regular query with logic that
creates the excel file similar to a crosstab. I ended up going this route
for a slight similar reason (I had other issues such as exceeding 255
columns as well). It's not too difficult to implement. Then you just make
headings in row 1 in Excel. Formatting is a bit more work.

My two cents,
Mark

You may be right (and I would guess you often are, contrary to your
statement
...).

I agree with your opinion in general about the column heading length, but
I
am trying to output a comparison report to Excel and this seemed the
easiest
method by which to denote which dataset's results were listed and let the
user know exactly what they are looking at.

I may have to do some truncation/abbreviation myself, or just exclude a
street address altogether.

I believe that maximum size is 64 characters. I could be wrong. I often
am
wrong.

IN my opinion, a column heading that long is suspect anyway.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Hi there,

I have written a crosstab that uses a concatenation of 3 fields for the
column heading ([StoreName] & " " & [Address] & " " & [City]), but
after
55-60 characters long, the query is truncating the column
heading...what is
the max size I can use here, or am I doing something incorrectly?

Thanks,
Tim