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

Mr. Barton,
I apologize for my delay in responding. I've been trying to do as you
instructed for almost a week and still cannot get it to work. Would you
please help me a little more?

My report is called: Grade 6 Mathematics Test Selection. It is pulling
selected questions from a query. 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.).

My reports left margin is 0.5" and column width is 3.65"; so my twips for
left margin would be 720 twips and 5256 twips for column width. When I put
in the code I either get an error on Me. or Left, or >=. Then when I go back
to the report, there are no changes.

Please help! I am in design view, I select the VBA icon, then I type in

Public Sub Column_Alpha_Change()
'Change Alpha in second column.

If Me.Left >= 720 + 5256 Then

Me.txtA = "F"
Me.txtB = "G"
....

End If

Should txtA be AnswerA_Label?

Help! This is the key to the puzzle.

Thanks again.

--
Helping the kids


"Marshall Barton" wrote:

> Public Schools wrote:
>
> >How do I write statement to change A to F; B to G; C to H; and D to J? For
> >example:
> >
> >I have a 2-column report. First column has question with A,B,C,D option
> >answer. Second column has question with A,B,C,D option answer BUT needs to
> >have F,G,H, J as the option. How do I make this happen?
> >
> >1. What is 2 +3? 2. What 4 X 5?
> >A. 5 A. 23 Should be F.
> >B. 8 B.17 Should be G.
> >C. 12 C. 20 Should be H.
> >D. 1 D. 9 Should be J.
> >
> >Currently, column two on my report has A, B, C, D due to report design.
>
>
> Assuming the A,B,C,D are in bound text box controls,
>
> If Me.Left >= {the report's left margin in twips} _
> + {the column width in twips} Then
> Me.txtA = "F"
> Me.txtB = "G"
> . . .
> End If
>
> --
> Marsh
> MVP [MS Access]
>

Public Schools wrote:
>I apologize for my delay in responding. I've been trying to do as you
>instructed for almost a week and still cannot get it to work. Would you
>please help me a little more?
>
>My report is called: Grade 6 Mathematics Test Selection. It is pulling
>selected questions from a query. 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.).
>
>My reports left margin is 0.5" and column width is 3.65"; so my twips for
>left margin would be 720 twips and 5256 twips for column width. When I put
>in the code I either get an error on Me. or Left, or >=. Then when I go back
>to the report, there are no changes.
>
>Please help! I am in design view, I select the VBA icon, then I type in
>
>Public Sub Column_Alpha_Change()
>'Change Alpha in second column.
>
>If Me.Left >= 720 + 5256 Then
>
>Me.txtA = "F"
>Me.txtB = "G"
>...
>End If
>
>Should txtA be AnswerA_Label?


If AnswerA_Label is a label control (instead of my assumed
text box control), then try using:

If Me.Left >= 720 + 5256 Then

Me.AnswerA_Label.Caption = "F"
Me.AnswerB_Label.Caption= "G"
....
End If

Make sure you call the procedure from the report's detail
section's Format event procedure.

--
Marsh
MVP [MS Access]

I'm sorry to bother you again, but I've encountered another problem with this
process. Page 1 works great in print preview. Second column is listed as F,
G, H, J; however, columns 1 and 2 of the pages that follow are F,G,H,J. Also
when it prints, page 1 converts to F, G, H, J. So when I print my report all
the questions in both columns are F,G,H,J. Am I doing something wrong?
Please help me. I've searched the community for information on references to
the second column but could not find an aswer.

Thank you, in advance, for your time.

P.S. You are a blessing!
--
Helping the kids


"Marshall Barton" wrote:

> Public Schools wrote:
> >I apologize for my delay in responding. I've been trying to do as you
> >instructed for almost a week and still cannot get it to work. Would you
> >please help me a little more?
> >
> >My report is called: Grade 6 Mathematics Test Selection. It is pulling
> >selected questions from a query. 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.).
> >
> >My reports left margin is 0.5" and column width is 3.65"; so my twips for
> >left margin would be 720 twips and 5256 twips for column width. When I put
> >in the code I either get an error on Me. or Left, or >=. Then when I go back
> >to the report, there are no changes.
> >
> >Please help! I am in design view, I select the VBA icon, then I type in
> >
> >Public Sub Column_Alpha_Change()
> >'Change Alpha in second column.
> >
> >If Me.Left >= 720 + 5256 Then
> >
> >Me.txtA = "F"
> >Me.txtB = "G"
> >...
> >End If
> >
> >Should txtA be AnswerA_Label?
>
>
> If AnswerA_Label is a label control (instead of my assumed
> text box control), then try using:
>
> If Me.Left >= 720 + 5256 Then
>
> Me.AnswerA_Label.Caption = "F"
> Me.AnswerB_Label.Caption= "G"
> ....
> End If
>
> Make sure you call the procedure from the report's detail
> section's Format event procedure.
>
> --
> Marsh
> MVP [MS Access]
>

Public Schools wrote:

>I'm sorry to bother you again, but I've encountered another problem with this
>process. Page 1 works great in print preview. Second column is listed as F,
>G, H, J; however, columns 1 and 2 of the pages that follow are F,G,H,J. Also
>when it prints, page 1 converts to F, G, H, J. So when I print my report all
>the questions in both columns are F,G,H,J. Am I doing something wrong?
>Please help me. I've searched the community for information on references to
>the second column but could not find an aswer.


What do you want them to be?

What is in the first column?

How does the second column relate to the first column?

--
Marsh
MVP [MS Access]

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.

I also tried to add a subreport for column 2 with the FGHJ but was unable to
generate the questions to flow on the test correctly and there is no way of
knowing the exact number of questions on the test because teachers will be
randomly selected them.

Thanks for you time,
I anxiously await your help.



--
Helping the kids


"Marshall Barton" wrote:

> Public Schools wrote:
>
> >I'm sorry to bother you again, but I've encountered another problem with this
> >process. Page 1 works great in print preview. Second column is listed as F,
> >G, H, J; however, columns 1 and 2 of the pages that follow are F,G,H,J. Also
> >when it prints, page 1 converts to F, G, H, J. So when I print my report all
> >the questions in both columns are F,G,H,J. Am I doing something wrong?
> >Please help me. I've searched the community for information on references to
> >the second column but could not find an aswer.
>
>
> What do you want them to be?
>
> What is in the first column?
>
> How does the second column relate to the first column?
>
> --
> Marsh
> MVP [MS Access]
>

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]