Conditional Formatting: Strike-through

[Guest]

I have a report that shows tasks that need to be completed. There are a
couple different values for the status field. One of the values is
"Deferred." I want to have them show up, but I want to have the text "striked
through." Is there a way to do this through the conditional formatting
feature? If not, do you have an idea of how I could simply accomplish the
task?

TIA for your help.

-Brandon

 

[Marshall Barton]

I have a report that shows tasks that need to be completed. There are a
couple different values for the status field. One of the values is
"Deferred." I want to have them show up, but I want to have the text "striked
through." Is there a way to do this through the conditional formatting
feature? If not, do you have an idea of how I could simply accomplish the
task?

AFAIK, that's a Word feature. In an Access report you can
approximate the strike through by drawing a line through the
text box using code in the text box section's Format event
procedure.

If txtStatus = "Deferred" Then
Line (txtStatus.Left, txtStatus.Top+txtStatus.Height/2) _
Step(txtStatus.Width,0)
End If

Maybe you can settle for using Conditional Formatting to
print the text in a different color (light gray)??

 

[Guest]

Thank you for the direction. I'll give it a try.

I did consider using grey as well, and I still may do that.

-Brandon