Conditionally formatting a line on a continuous form

[oleBucky]

I have a subform in which is a continous form. The subform only has two controls, a text value and a numeric value. The numeric value is in a text box called "txtRoll". I want the line on the bottom of the subform's row (named "LineEvery5") to show conditionally if txtRoll = 30, 35, 40 or 45. As a line will not respond to conditional formatting (the option on the menu is "grayed out"), I tried the following code on the OnCurrent event of the subform. (I simplified the constraints as I was having trouble with the OR syntax)

 
    If Me.txtRoll = 30 Then
        Me.LineEvery5.Visible = True
            Else:
            Me.LineEvery5.Visible = False
    End If

I also tried this.

 
    If Me.txtRoll.Value = 30 Then
        Me.LineEvery5.Visible = True
            Else:
            Me.LineEvery5.Visible = False
    End If

Interestingly, in both cases, LineEvery5 disappears. If I comment out the code, LineEvery5 is visible on every row. Clearly I am not getting a "True" from my If clause. What code might give me a True when txtRoll equals 30, 35, 40, or 45?

[pbaldy]

You can do that type of formatting on a report, not a form. The report has a detail format event that fires for every record. Forms don't have that. The current event will only fire for the "current" record, and will apply the formatting to every record. That's why the line is blank for every row. If you selected the record with 30, every row would display the line.

The only solution that comes to mind is using a textbox with a control source of just spaces, with underlining on. Use conditional formatting on that (setting the font).

[oleBucky]

You can do that type of formatting on a report, not a form.

OUCH! That makes getting to where I want to be difficult.

While I work on your text box-with-underlined-spaces solution, I thought I'd post a capture of my form to illustrate the issue. Each column of text and number combinations is a subform. I've turned off the lines on the first subform.

My goal is to carry each horizontal line on the main form (below 30, 35, 40, 45 and 50) fully across the form while leaving out the other horizontal lines. I've tried, without success, to "trick" access into letting me set the BackColor/BackStyle of the detail of the subform to transparent so the lines passing behind the subform show. I've also tried, equally unsuccessfully, to bring the main form lines in front of the subform.

I am sure those of you more versed in the code stand a better chance of making one of these two routes work as well as some other, more creative solution.

[oleBucky]

The only solution that comes to mind is using a textbox with a control source of just spaces, with underlining on. Use conditional formatting on that (setting the font).

The Force is strong with this one!

[pbaldy]

It's working for you? It feels like a kludge, but I can't think of a better way.

[oleBucky]

It's working for you? It feels like a kludge, but I can't think of a better way.

A Kludge? Maybe. But to paraphrase Rural Guy on one of my other solutions, there's a lot to be said for "It works."