How to get around 22 inch (55.87 cm) page length limit in Access 2

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

Guest

I've been using Access 2007 to design a questionnaire that can be completed
on-screen. All was going well until I had used up the first 22 inches, when I
discovered that Access has an in-built limit on page length. I've tried
obvious things like inserting page breaks, changing 'Detail Properties' etc,
but I can't find any way around it.

Can anyone advise the most simple way of extending the length of an Access
document?
 
Hi

Just an idea. Use the AfterUpdate of the last question to close the form
and open the next one.
 
I've been using Access 2007 to design a questionnaire that can
be completed on-screen. All was going well until I had used up
the first 22 inches, when I discovered that Access has an
in-built limit on page length. I've tried obvious things like
inserting page breaks, changing 'Detail Properties' etc, but I
can't find any way around it.

Can anyone advise the most simple way of extending the length
of an Access document?
Click to expand...
sounds like you are storing all the questions for each survey in
a single row and not one question per row.

The proper scheme for a survay uses 3 tables or more, one for
survey heading information, another for the questions and a
third for the answers.

tblsurvey
surveyID (pk)
surveyDate
surveyResponderName
surveyResponderAddress
surveyTakerName

tblQuestions
QuestionID (pk)
QuestionText
CorrectAnswer

tblAnswers
SurveyID (pk) (fk to tblSurvey)
QuestionID (pk) (fk to tblQuestions)
Answer

using that structure allows an infinite number of questions, and
in a continuous form your 22 inch limit is per question, and I
cannot see how any question would be so big as to exceed that.
 
Back
Top