How can I fit all my details in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I fit all my details in a report. The report is based is a form that
has boxes around the detail and page breaks. I received an error "The
control or subform control is to large for this location". How can I correct
this.
 
For one thing you could go to File > Page Setup and change the margins. For
another you could get rid of the page breaks. You can add them back later
as needed. If still no luck, try adding controls a few at a time,
previewing after each addition. Conversely, you could remove controls. It
is a process of elimination.
 
BruceM,

I am not familiar as to what the controls will allow me to do. I am pretty
new to developing in Access. An example would be helpful. I played with the
margins and that did not help. I am testing subreports, adding my remaining
details in a second report and adding it to my main report as subreport. If
there is a better way please assist.

Thanks,
Eman
 
A control is a text box, combo box, label, line, etc. on a form or report.
A control can be bound to (linked to) a field in a table or query, or it can
be unbound. Access starts with tables and their relationships to other
tables. Without knowing about your database structure it is impossible to
offer any advice.

I do have to say that based on your questions I suspect you are quite near
the beginning of the learning curve. If so, you would do well to step back
from a project until you have had some time to study the program. While it
is possible to get results out of Word or even Excel by poking around until
you get something to sort of work, you cannot do that with Access. It is
not intuitive.

A place you could start investigating Access would be at
http://office.microsoft.com/. Follow the training link. You could also do
a newsgroup search for "Access tutorial" or "Access Book" to see other
suggestions.
 
Back
Top