conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi ,

i would like to use conditional formatting on a form that based on a search
query in a table, i would like to underline or bold the words that i search
for in the query, i have tried to use conditional formatting but i only
underline if the searched words is the only words in the field. i have tried
to use like expression but it does not work.
the serched words has a input text field in the same field.

please help me
thanks in advanced
Alon
 
Hi ,

i would like to use conditional formatting on a form that based on a search
query in a table, i would like to underline or bold the words that i search
for in the query, i have tried to use conditional formatting but i only
underline if the searched words is the only words in the field. i have tried
to use like expression but it does not work.
the serched words has a input text field in the same field.

please help me
thanks in advanced
Alon
Click to expand...

Hi Alon,

You may want to look at Stephan Lebans Rich Text ActiveX:
http://www.lebans.com/richtext.htm


_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Hi Alon
Try this on the load event of the form,

' To create a new condition for the field
Me.FieldName.FormatConditions.Add acExpression, , 1
' To change the format of the field
With Forms("1111").Controls("dddd").FormatConditions(0)
.BackColor = RGB(255, 255, 255)
.FontBold = True
.ForeColor = RGB(255, 0, 0)
End With
' Please play with this option, you might get to the result you are looking
for
 
Back
Top