Solved Conditional formatting on cell in continuous form when vbCrLf found (1 Viewer)

[Brother Arnold]

I'm trying to conditionally format a long text field in a continuous form. The form only shows the first line of text so I want to highlight the field if it consists of more than one line i.e. if it contains a vbCrLf. In code I can do this easily enough on a normal form for one record with UBound(Split([txtNotes], vbCrLf))>0 but I can't get it to work when I use it as an expression using conditional formatting. I can get [txtNotes]>"" to work on any cells that aren't blank so close but no cigar. Any ideas?

 

[arnelgp]

use the Expression:

Instr(1, [txtNotes] & "", Chr(13)) <> 0

 

[Brother Arnold]

use the Expression:

Instr(1, [txtNotes] & "", Chr(13)) <> 0

Works like a dream. Thank you