Hi All,

I have a very strange problem. I'm trying to add a conditional format so that if a field in a column contains a particular string its 'backcolor' changes.

the following WORKS:
------------------------
Me.Hostname.FormatConditions.Delete

Set objFrc = Me.Hostname.FormatConditions.Add(acFieldValue, acEqual, 0)
MsgBox "running"
With Me![Hostname].FormatConditions(0)
.BackColor = vbGreen

End With
---------------------------
the following DOESNT WORK:
-----------------------------
Me.Hostname.FormatConditions.Delete

Set objFrc = Me.Hostname.FormatConditions.Add(acFieldValue, acEqual, "string")
MsgBox "running"
With Me![Hostname].FormatConditions(0)
.BackColor = vbGreen

End With
----------------------------

If I replace the '0' with a string "string" it does not work. It only accepts constants not strings. What am i doing wrong?


Thanks in advance