Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Conditional Format & VLOOKUP (Maybe) on Access 2007 Form Redeux

Avatar of Anne Troy
Anne TroyFlag for United States of America asked on
Microsoft Access
25 Comments1 Solution421 ViewsLast Modified:
Preamble:
Please, no comments on the fact that this DB doesn't follow general standards. I can't help that right now. I created previous questions and have attempted to take direction from them of creating relationships and using queries, and none of this worked. A lot of time was put into those responses, so I awarded those experts and now I must move on.  If you can DO THIS FOR ME, great. Otherwise, I'll have to live without it. It must be done in Access 2007 and provided in accdb file format. If necessary, I can be available by phone.

Question:
On the Issue Details form, I would like to conditionally format the "Assigned to" textbox to be fill/back color yellow if the machine's username matches the current user's username in the Contacts list. The dropdown currently contains a combo box with first and last name from a query called Contacts Extended. I did add Username to that query. I just don't know how to proceed.

Thanks so much for your time.
Issues3.accdb