MS Access 2010
My current project involves creating examinations from a database of Questions and Answers.
The Questions are in one table and the Answers in another with the Question Number data field forming the One-To-Many relationship.
I have created a query to randomise the Answer order and the examination is grouped by Question number, i.e. the Question forms the Group Header and the optional Answers the detail within each record. Question admin details (Learning Objective codes, score, etc.) form the Group Footer.
So far so good. Everything works tickety boo................
Unfortunately, I cannot seem to keep whole question & answer records on one page, when there isn't enough space for it all to fit on the current page being used. By this I mean, e.g. Questions 1, 2 and 3 are on page 1 in their entirety then Question 4 has the Group Header (question text) on the page along with one or two of the optional Answers then the rest of the detail section (the remaining optional Answers) plus the Group Footer move on to the next page.
The 'Force New Page' option doesn't work in this scenario. If I apply it to the Group Header Section I only get one question per page and if applied to the Detail Section I only get one optional answer per page.
Any ideas o learned ones???
My current project involves creating examinations from a database of Questions and Answers.
The Questions are in one table and the Answers in another with the Question Number data field forming the One-To-Many relationship.
I have created a query to randomise the Answer order and the examination is grouped by Question number, i.e. the Question forms the Group Header and the optional Answers the detail within each record. Question admin details (Learning Objective codes, score, etc.) form the Group Footer.
So far so good. Everything works tickety boo................
Unfortunately, I cannot seem to keep whole question & answer records on one page, when there isn't enough space for it all to fit on the current page being used. By this I mean, e.g. Questions 1, 2 and 3 are on page 1 in their entirety then Question 4 has the Group Header (question text) on the page along with one or two of the optional Answers then the rest of the detail section (the remaining optional Answers) plus the Group Footer move on to the next page.
The 'Force New Page' option doesn't work in this scenario. If I apply it to the Group Header Section I only get one question per page and if applied to the Detail Section I only get one optional answer per page.
Any ideas o learned ones???