Seemingly Easy Code Error

[turtle]

Sorry if this double posts...

I am trying to set the forecolor on a field of a form to Red if
priority is equal to High.
The Priority field is combobox if that matters.

If Me.Priority = "high" Then
Me.SAP_MM.ForeColor = 255
Else
Me.SAP_MM.ForeColor = 0
End If

After running this on even current i get a compile error: Method or
data member not found.

I checked and my DAO 3.6 reference is checked.

TIA,
KO

[Allen Browne]

Is there a *control* named Priority?
If not (i.e. if it's a field but not a text box), try creating a text box
for it.

It might be easier and more efficient to use Conditional Formatting onthe
SAP_MM control:
Expression: Priority="high"

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"turtle" <ko****@vistacontrols.comwrote in message
news:58**********************************@m45g2000 hsb.googlegroups.com...

Sorry if this double posts...

I am trying to set the forecolor on a field of a form to Red if
priority is equal to High.
The Priority field is combobox if that matters.

If Me.Priority = "high" Then
Me.SAP_MM.ForeColor = 255
Else
Me.SAP_MM.ForeColor = 0
End If

After running this on even current i get a compile error: Method or
data member not found.

I checked and my DAO 3.6 reference is checked.

TIA,
KO

[turtle]

On Sep 11, 9:34*am, "Allen Browne" <[e-mail]:

Is there a *control* named Priority?
If not (i.e. if it's a field but not a text box), try creating a text box
for it.

It might be easier and more efficient to use Conditional Formatting onthe
SAP_MM control:
* * Expression: * * * * * *Priority="high"

--
Allen Browne - Microsoft MVP. *Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"turtle" <[e-mail] in message

news:58**********************************@m45g2000 hsb.googlegroups.com...

Sorry if this double posts...

I am trying to set the forecolor on a field of a form to Red if
priority is equal to High.
The Priority field is combobox if that matters.

If Me.Priority = "high" Then
Me.SAP_MM.ForeColor = 255
Else
Me.SAP_MM.ForeColor = 0
End If

After running this on even current i get a compile error: *Method or
data member not found.

I checked and my DAO 3.6 reference is checked.

TIA,
KO- Hide quoted text -

- Show quoted text -

Thanks,
the conditional formatting worked great!
KO