Please help can't define a Access report for a query with 29 fields

  • Thread starter Thread starter Karen Middleton
  • Start date Start date
K

Karen Middleton

I have a Access Query that has 29 columns in it and th Access query as
such works fine and generates a output and it accepts a parameter
value before running the query.

I am using the above query as the basis for the Access Report the
problem I face now in the Access report even though I have chosen my
Page orientation to be Landscape and when I see all the page header
columns and the page detail data bound columns are set to font size
8/Arial almost 60% of the columns in the report are missing on the
right side appears Access does not have space to accomodate it.

I am bewildered struggled so much cannot get all the columns on the
page header and the page detail in fact I do not even care to print
this report I want to be able to view this in a nice formatted way on
the screen.

Can any of you please advice me the trick of formatting it so that all
the columns appear in the page header and in the page detail please.
All I care is I want to be able to view all the columns in a nice
formatted way on the screen in the Access report.

Thanks
Karen
 
Karen Middleton said:
I have a Access Query that has 29 columns in it and th Access query as
such works fine and generates a output and it accepts a parameter
value before running the query.

I am using the above query as the basis for the Access Report the
problem I face now in the Access report even though I have chosen my
Page orientation to be Landscape and when I see all the page header
columns and the page detail data bound columns are set to font size
8/Arial almost 60% of the columns in the report are missing on the
right side appears Access does not have space to accomodate it.

I am bewildered struggled so much cannot get all the columns on the
page header and the page detail in fact I do not even care to print
this report I want to be able to view this in a nice formatted way on
the screen.

Can any of you please advice me the trick of formatting it so that all
the columns appear in the page header and in the page detail please.
All I care is I want to be able to view all the columns in a nice
formatted way on the screen in the Access report.
Click to expand...

If you are using the Report Wizard be aware that it has limitations that
reports (in general) do not. Simply open the report in design view and
rearrange as required. If you *are* arranging manually and can't get them
all to fit then you are stuck. You can't put 10 pounds of um...stuff in a
5 pound sack.
 
Back
Top