Using Line control on a Report- visible or not?

[lfaust58]

Hi there--

I've run into a snag and wonder if y'all could help me.

I'm building a DB & Report using Access 2010 beta, I've got a table of counselors, and printing them on a report by category just fine, but I'd like to have a line control (named line33) that I've placed over the textboxes on my report be visible or not depending on a yes/no checkbox on the counselor table (field named "Current").

The end result would be a report of counselors with the ones NOT current with a line through their info. The purpose being to motivate the "struckthrough" counselors to get current.

Thanks in advance

Larry
(reply here or to lfaust58@gmail.com)

 

[dhookom]

I would probably use a text box with a control source like:

=IIf([Current],Null,"_______________________________" )

Make sure the background is set to transparent. Position the control over the record in the report.

Duane
Hook'D on Access
MS Access MVP