Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Reports > Alternate Rows ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 29115 of 30244
Post > Topic >>

Alternate Rows - Change of Text

by =?Utf-8?B?UHVibGljIFNjaG9vbHM=?= <PublicSchools@[EMAIL PROTECTED] Aug 6, 2008 at 12:05 PM

Hello.

I am having trouble writing an If.Then.Else statement and need assistance.

My re****t is set up as follows:

Question No.    Correct Answer  Re****ting Category     Descriptor
1.                       B                       002                      
 
Estimation
2.                       D                      006                       

Geometry
3.                       C                       007                      

Patterns
4.                        C                     001                       

Statistics
5.                        A                     003                       
 
Algebra
6.                       C                      004                       
  
Numbers
etc.

I would like the even numbered/row answers to be:
A=F
B=G
C=H
D=J

The Question No is a text box and is unbound.  The Correct Answer field is

[CorrectAnswer]. 

I've tried the following, but it does not work.  Any suggestions?

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If Me.[LineNum] Mod 2 = 0 Then
Me![CorrectAnswer].Text "A" = "A"
Me![CorrectAnswer].Text "B" = "B"
Me![CorrectAnswer].Text "C" = "C"
Me![CorrectAnswer].Text "D" = "D"
Else
Me![CorrectAnswer].Text "A" = "F"
Me![CorrectAnswer].Text "B" = "G"
Me![CorrectAnswer].Text "C" = "H"
Me![CorrectAnswer].Text "D" = "J"
End If


End Sub

Thanks for your time.
-- 
Helping the kids
 




 8 Posts in Topic:
Alternate Rows - Change of Text
=?Utf-8?B?UHVibGljIFNjaG9  2008-08-06 12:05:01 
RE: Alternate Rows - Change of Text
=?Utf-8?B?S2xhdHV1?= <  2008-08-06 13:11:02 
RE: Alternate Rows - Change of Text
=?Utf-8?B?UHVibGljIFNjaG9  2008-08-25 10:36:04 
RE: Alternate Rows - Change of Text
=?Utf-8?B?S2xhdHV1?= <  2008-08-25 11:34:13 
Re: Alternate Rows - Change of Text
Marshall Barton <marsh  2008-08-25 17:18:07 
Re: Alternate Rows - Change of Text
=?Utf-8?B?S2xhdHV1?= <  2008-08-25 15:24:08 
Re: Alternate Rows - Change of Text
=?Utf-8?B?UHVibGljIFNjaG9  2008-08-26 06:21:01 
Re: Alternate Rows - Change of Text
=?Utf-8?B?S2xhdHV1?= <  2008-08-26 06:46:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Nov 20 5:55:05 CST 2008.