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.

dans l'article EC53D8E2-C06E-4EB7-BF22-(E-Mail Removed), SAP2 à
(E-Mail Removed) a écrit le 23/01/08 2:31*:

> 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.