[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 732
  • Last Modified:

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

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
aijreal
Asked:
aijreal
1 Solution
 
puppydogbuddyCommented:
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
 
aijrealAuthor Commented:
Thankyou!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now