Avatar of Sandra Smith
Sandra Smith
Flag 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
Microsoft DevelopmentMicrosoft ApplicationsMicrosoft Access

Avatar of undefined
Last Comment
Sandra Smith

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jeffrey Coachman

<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
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"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
Jeffrey Coachman

Ah, ...never noticed that...

;-)

Jeff
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
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
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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

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

mx
Sandra Smith

ASKER
Yes that did it.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.