OK my problem is as follows,
I am using Access 2003 and i am running a form which already uses the 3 available conditional format options.
I have read on the forum about VBA conditional formatting and this didnt seem to be to bad.
However i have used the available code , but VBA is telling me it doesnt recoginse forecolor, nor indeed does it recongise backcolor either.
the code i was using was
Select Case Me.[stock in]
Case Is =-1
Me.[customer order no].forecolor = 255
End Select
Any thoughts would be much appreciated.
Andy B
I am using Access 2003 and i am running a form which already uses the 3 available conditional format options.
I have read on the forum about VBA conditional formatting and this didnt seem to be to bad.
However i have used the available code , but VBA is telling me it doesnt recoginse forecolor, nor indeed does it recongise backcolor either.
the code i was using was
Select Case Me.[stock in]
Case Is =-1
Me.[customer order no].forecolor = 255
End Select
Any thoughts would be much appreciated.
Andy B