Column Width Adjustment

[johnbernard]

I have a report that has many columns. For some reason
it is limiting my page width in landscape at 22" and will
not let me change. It seems that it is randomly giving
column widths to these columns. I must set up 50 or so
reports like this and want a way to extend the page width
and therefore the column widths wider. I was hoping not
go through by hand and widen every column. However, I
can't seem to make the page wider than 22" anyway.

Any ideas?

 

[Marshall Barton]

I have a report that has many columns. For some reason
it is limiting my page width in landscape at 22" and will
not let me change. It seems that it is randomly giving
column widths to these columns. I must set up 50 or so
reports like this and want a way to extend the page width
and therefore the column widths wider. I was hoping not
go through by hand and widen every column. However, I
can't seem to make the page wider than 22" anyway.

Look for another way to present the data, possibly using
Excel. The Access report design space is limited to 22"
wide and 200" high with individulal sections having a
maximum height of 22".

Something smells fishy when you say you need to create 50
reports like this?? Its more usual to create one (or a
few) reports that adapt to the needs of the other output
requirements, often by just applying different filters to
the data.

 

[johnbernard]

-----Original Message-----



Look for another way to present the data, possibly using
Excel. The Access report design space is limited to 22"
wide and 200" high with individulal sections having a
maximum height of 22".

Something smells fishy when you say you need to create 50
reports like this?? Its more usual to create one (or a
few) reports that adapt to the needs of the other output
requirements, often by just applying different filters to
the data.

Thanks for the info on the design space.

I have to generate a report for every event that my
company hosts(50+). Just a fancy looking version of the
table itself, for reference. There are other reports
that I must create that have more specific information to
display.

 

[Marshall Barton]

-----Original Message-----

Thanks for the info on the design space.

I have to generate a report for every event that my
company hosts(50+). Just a fancy looking version of the
table itself, for reference. There are other reports
that I must create that have more specific information to
display.

Have you tried to create just one report that lists the
desired data, but for all events? There are several simple
techniques to then filter the report's data to display only
a specified event?

 

[Guest]

-----Original Message-----




Have you tried to create just one report that lists the
desired data, but for all events? There are several simple
techniques to then filter the report's data to display only
a specified event?

Don't know how? Any input is appreciated.
I did this with a form to input data to multiple tables,
but how to do the same with a report? Do you have an
example?
John

 

[Marshall Barton]

Don't know how? Any input is appreciated.
I did this with a form to input data to multiple tables,
but how to do the same with a report? Do you have an
example?

The quick and dirty approach is to add a prompting criteria
to the query. E.g. under the event field use a criteria
something like:
=[Enter the event ID]
then when you run the report, a pop up will appear to prompt
you to supply the desired event.

A better way is to use a form with a text box for users to
enter the event ID and a button to initiate the report. The
click event procedure then uses the OpenReport method's
WhereCondition argument to apply a constructed criteria:

Dim stDoc As String
Dim stWhere As String
stDoc = "nameofreport"
stWhere = "EventID = " & txtEventID
DoCmd.OpenReport stDoc, acViewPreview, , stWhere