Test Generator help with blanks and if/then statement
I created a test generator using mail merge.
«QuestionID». «strQuestion»
«Option_A_ID» «Option_A»
«Option_B_ID» «Option_B»
«Option_C_ID» «Option_C»
«Option_D_ID» «Option_D»
Answer: «Answer»
For my exam, I have multiple choice, True/False, and Fill in the blank. I have had some success putting it together but IF/Then statements and Blanks are really kicking my butt.
Option_A_ID is "a." Option_B_ID is "b." Option_C_ID is "c." Option_D_ID is "d."
For True/False questions, I don't want Option_C_ID or Option_C to still. I was thinking: If Option_C is Blank, don't show Option_C_ID and suppress that line.
Same idea for Fill in the blank. If Option_A is blank, only show Option_A_ID and a "_____________________________________________ ____ ____".
Is there a way that I could do this?
|