Change Colour of Textbox content on data 1

[696796]

Morning all,

I have inherited a database and need to create a report.

I want for the data in a textbox(Coin Mech No) to display in red if a condition is met.

The condition is if the data contains an "R" anywhere in the string.

I have tried

If Me.Coin Mech No islike "*R*" Then
    Me.Coin Mech No.Forecolor = vbred
End If

I can't see an easy way to format these textboxes. I am using Access 97. Also, the naming convention is poor, so are the spaces in the name going to affect anything or is it just bad practice?

I have searched other posts but cannot find what i need.

Thanks for your help,

Alex

 

[lupins46]

if instr(me![coin mech no],"r")>0 then
'there is an r