Multiple Conditional Formatting in Datasheet View Form

[sap2]

Scenario:
Access 2003
Datasheet view form
Control is a text box- PN
I have 6 conditions for this text box.

The 'Select Case' works in the On Format Event in one of my reports but the same does not work when putting into the datasheet view form. I have placed it in the On Current, On Open, and On Load Events with no change to the back color of PN.

Any suggestions? Thanks in advance.

 

[genomon]

The 'Select Case' works in the On Format Event in one of my reports

Which pretty much tells us zilch. What is "PN"?
Please explain your problem & maybe post some code, can't tell anything from your post...

All I ask is a chance to prove that money can't make me happy.