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?