2 Column Rpt-Even numbered questions need different alphab..

IT WORKED! IT WORKED! IT WORKED! YOU ARE SUPER GREAT!!!

Thank you!

My best to you!
--
Helping the kids


"Marshall Barton" wrote:

> Public Schools wrote:
>
> >Background: I am developing a test for students. Teachers randomly select
> >questions on a form I designed. I've developed a query for the selected
> >questions. This produces the report/test for the kids to take. The test has
> >to be 2 columns per page. I had to use object fields for the answer options
> >because this is a math test which has a lot of equations and graphics. I
> >pasted pictures in MSWord and copied and pasted picture and question into
> >object field.
> >
> >Question: I've set page to have 2 columns using the page setup on the
> >report. I added a text box to allow numbers to flow succinct. I've hidden
> >actual question number because the query generated random test questions but
> >I still needed to link question ID to report for test purposes .
> >
> >I would like page 1 to have question 1 and 2 of test. Question 1 answer
> >selection should be A, B, C, D and Question 2 answer selection should be F,
> >G, H, J. On page 2, Question 3 answer selection should be A, B, C, D and
> >Question 4 answer selection should be F, G, H, J and so on.
> >
> >ex.
> >Page 1
> >Name ____________
> >Date _____________
> >
> >1. What is 2 +3? 2. What 4 X 5?
> >
> >
> >A. 5 F. 23
> >B. 8 G.17
> >C. 12 H. 20
> >D. 1 J. 9
> >
> >Page 2
> >3. Which of the following shapes 4. Which of the following could
> > is a triangle? not be the graph of function x?
> >
> >A. Picture of circle F.Picture of a graph
> >B. Picture of triangle G. Picture of a graph
> >C. Picture of square H. Picture of a graph
> >D. Picture of rectangle J. Picture of a graph
> >
> >Page 3 ....
> >
> >The answers -- A,B,C,D are labels to bound object frames (i.e. Label:
> >AnswerA_Label is attached to Bound Object Frame A, Label: AnswerB_Label is
> >attached to Bound Object Frame B, etc.). I need all the even numbered
> >questions to be labeled F, G, H, J. What you suggested worked great for the
> >first page. However when I hit print it changed to FGHJ.
>
>
> Let's try changing the code to:
>
> If Me.Left < 2000 Then
> Me.AnswerA_Label.Caption = "A"
> Me.AnswerB_Label.Caption= "B"
> Me.AnswerC_Label.Caption = "C"
> Me.AnswerD_Label.Caption= "D"
> Else
> Me.AnswerA_Label.Caption = "F"
> Me.AnswerB_Label.Caption= "G"
> Me.AnswerC_Label.Caption = "H"
> Me.AnswerD_Label.Caption= "J"
> End If
>
> --
> Marsh
> MVP [MS Access]
>