Solved

Using MS Access 2003, change the color of a singe row in a continuous forms subform

Posted on 2010-08-28
2
672 Views
Last Modified: 2012-05-10
Experts,

I have a subform accessing a single table, the subform is set to continuous forms with an update button in each row. When the update button is clicked, I want to change the color of the detail ONLY for the row selected. Instead it's changing the color for all rows.

Can this be done.

Feel free to give anwers using VBA.
0
Comment
Question by:aijreal
2 Comments
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 250 total points
ID: 33553124
Try placing the following code in your update button:
If Me.CurrentRecord Then
   Me.BackColor = vbRed
End If
________________________________________

try this if the above doesn't work, but this will only highlight one control:
Open the subform in Design View, and select the first control.
Go to Format | Conditional Formatting.
Under Condition 1, select Field Has Focus.
Click the Fill/Back Color button, and select yellow.
Click OK.
0
 

Author Closing Comment

by:aijreal
ID: 36576906
Thankyou!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Creating a tuition video for users 2 77
Excel Automation of Autosum 23 98
How to open outlook macro editor w/o running Outlook ? 1 35
COPY from excel to notepad 3 35
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now