I've got a subform where the field's conditional formatting would
be expressed in VBA as:
-----------------------------------------
If [IsApproved]=False Then
.ForeColor=255 (red)
.BackColor=15329769 (lite gray)
End If
-----------------------------------------

But I'd like to take it further and say that
if I've got .Locked=False for the field in question,
..BackColor=(white).... Giving the user a visual
acknowledgement that the form is in "Edit" mode.

So, bottom line, is there anyplace where I can fine-tune/supplement conditional
formatting?
--
PeteCresswell

Per (PeteCresswell):
>-----------------------------------------
> If [IsApproved]=False Then
> .ForeColor=255 (red)
> .BackColor=15329769 (lite gray)
> End If
>-----------------------------------------
>
>But I'd like to take it further and say that
>if I've got .Locked=False for the field in question,
>.BackColor=(white).... Giving the user a visual
>acknowledgement that the form is in "Edit" mode.

Oops! Got it. The magic word is "Me."

viz
---------------------------------------
[IsApproved]=False And Me.Locked=True
---------------------------------------
--
PeteCresswell

Per (PeteCresswell):
>
>Oops! Got it. The magic word is "Me."
>
>viz
>---------------------------------------
>[IsApproved]=False And Me.Locked=True
>---------------------------------------


Oops... again...

Seemed to work until I tried to get cute and add another condition

Viz:
-----------------------------------------
[IsApproved]=False And Me.Locked=True (.BackColor=gray)
[IsApproved]=False And Me.Locked=False (.BackColor=white)
-----------------------------------------

Then it all stopped working until I went back to
a single "[IsApproved]=False"....

i.e. the compound logic stopped working altogether.

Anybody been here?
--
PeteCresswell