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

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
 
R

Rick Brandt

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top