Conditional Formatting on a Line 2

[perrymans]

I have a line above the text box in the detail section.

I only want the line to display if there is information in the textbox for that detail.

How can this be done? Conditional Formatting only enables for the textbox, not the line.

Thanks. Sean.

 

[PWise]

in
Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

me.linename.Visible=me.textboxname>

 

[dhookom]

This code might not work as Null is not the same as "". Null is unknown so you can't compare it to anything.

Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
   me.linename.Visible = me.textboxname & "" > ""
End Sub

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[perrymans]

I used Duane's code, but they were both right.

Thanks for the solution!

Sean.