"Red Line"

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi,

I'd like to "red line" a record on an Access report (or "strike out") based
on content, similar to how a person might "red line" a string of text in
Word. My goal is to show a line marked erroneous, deliberately not removing
it from view.

Any ideas?
 
Hi,

I'd like to "red line" a record on an Access report (or "strike out") based
on content, similar to how a person might "red line" a string of text in
Word. My goal is to show a line marked erroneous, deliberately not removing
it from view.

Any ideas?
Click to expand...

Access does not support 'overstrike', however you can move a line and
position it over some control as needed or if it's always in the same
position, just make it visible or not.

Line277.visible = [SomeControl] = SomeCriteria

To actually move the line to position it over some text:
Code the detail Section format event:

If [Overtype] = Some criteria Then
Line277.Visible = True
Line277.Left = [Overtype].Left
Line277.Top = [Overtype].Top + 1440*.1 ' 1/10 of an inch below
the top of the control, measured in Twips.

ElseIf [Overtype] = other criteria Then
Line277.Visible = True
Line277.Left = [Control2].Left
Line277.Top = [Control2].Top + 1440*.1
Else
Line277.Visible = False
End If
 
Back
Top