crosstab report colum headings

Hi,

I have a crosstab report based on Duane Hookom's crosstab database. It
works very well and I appreciate all the help I received last year in getting
it to work. Now, I have a lot of data to report and I am trying to condense
it down to as few pages as possible. I can get the data (detail) to be 10
columns wide in the report and still be readable. However, the last two
column headings wrap into the next row even though there is plenty (at least
it appears that way) of width room left on the page.

I have tried various things, but really do not know how to make it not wrap.
I am fairly sure that it has something to do with the subreport I use for the
colum headings but . . .

Please help a frustrated hacker who has no more hair to pull out! :-)
--
javablood

If you are using the dynamic crosstab report solution, what value are you
using for pbytNumColumns?

Also check the design view of the crosstab query to see what is in the
Column Headings property. If this property is
Column Headings: "A","B","C","D","E","F","G","H"
you will see only 8 columns. To see 10 columns, add "I","J".

--
Duane Hookom
Microsoft Access MVP


"javablood" wrote:

Hi,

I have a crosstab report based on Duane Hookom's crosstab database. It
works very well and I appreciate all the help I received last year in getting
it to work. Now, I have a lot of data to report and I am trying to condense
it down to as few pages as possible. I can get the data (detail) to be 10
columns wide in the report and still be readable. However, the last two
column headings wrap into the next row even though there is plenty (at least
it appears that way) of width room left on the page.

I have tried various things, but really do not know how to make it not wrap.
I am fairly sure that it has something to do with the subreport I use for the
colum headings but . . .

Please help a frustrated hacker who has no more hair to pull out! :-)
--
javablood