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
Sandra
Microsoft DevelopmentMicrosoft ApplicationsMicrosoft Access
Last Comment
Sandra Smith
ASKER CERTIFIED SOLUTION
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.
"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
Good news is that A2010 has lifted that limit ...
mx
Ah, ...never noticed that...
;-)
Jeff
;-)
Jeff
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
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
OK ,.. it should work. After which, we will replace Environ() with something better.
mx
ASKER
Yes that did it.
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