Link to home
Start Free TrialLog in
Avatar of Sandra Smith
Sandra SmithFlag for United States of America

asked on

Conditonal format on sub-form based on who is logged onto the form

I have an ACCESS 2003 forms/subform. However, depending on who is logged in, I need the Created_By field in the subform to be red/yellow.  That is, if the person using the form is Sarah and a field in the subform is also Sarah, I need the field on the subform to be red/yellow.  I am in the COnditonal formatting dialog box and assume it would be an experssions, but not sure how to write it.

Sandra
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
<No points wanted, just a note>
As your users grow, note that CF has a max of 3 conditions by default.

There are ways around this, of course.
I am sure MX can guide you through...

;-)

Jeff
"As your users grow, note that CF has a max of 3 conditions by default."
Good news is that A2010 has lifted that limit ...

mx
Ah, ...never noticed that...

;-)

Jeff
Avatar of Sandra Smith

ASKER

Yes, i am so hoping they go to 2010!  

Now, DatabaseMX, I am going to try your suggestion and yes, I mean Windows Login.  This is a form/subform so I hope it works.  Something like Me.Parent.txtUserID.

Sandra
Also ... the CF dialog (designer) is MUCH nicer in A2010 -

OK ,.. it should work. After which, we will replace Environ() with something better.

mx
Yes that did it.