Solved

Access 2007 - datasheet, make selected row change background color

Posted on 2011-02-21
9
4,167 Views
Last Modified: 2012-05-11
I've got a form with a subform on it.  The subform is a continuous datasheet.  The purpose of the datasheet is not to enter data, but simply to display data.

When I user clicks on one of the rows in the datasheet I would like it's background color to change.  Or in other words, the record with focus should have a background color, and records should lose the background color on blur.
0
Comment
Question by:JosephEricDavis
  • 5
  • 3
9 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 34947358
?continuous datasheet,  is it continuous form or datasheet
0
 
LVL 7

Author Comment

by:JosephEricDavis
ID: 34947370
Well yes, a continuous form.
0
 
LVL 7

Author Comment

by:JosephEricDavis
ID: 34947383
I've found this...

http://bytes.com/topic/access/answers/847939-change-background-color-entire-row-s

Which talks about placing a rectangle with conditional formatting behind all the controls in a record.

What I'm not sure how to do though is to somehow trigger the value that the conditional formatting depends on in such a way that the current record selected would have the highlighted rectangle in the background.

I'm trying to use the Form_Current() event.  Is there a way to manipulate the controls of the current row from within this function?
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
ID: 34947425
I use this:

http://www.lebans.com/conditionalformatting.htm


Added support for Datasheet view and SubForms.

A2KConditionalFormatting.zip is a sample MDB demonstrating how to programmatically setup Conditional Formatting to simulate:

1) Highlighting of the Current Row for a Form in Continuous or Datasheet View

2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet View
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 7

Author Comment

by:JosephEricDavis
ID: 34947455
That page is very unclear.  Maybe you could go through there and help me find the answer I need from it.
0
 
LVL 21
ID: 34947598
JosephEricDavis,

Did you get a chance to see the working example in the link I provided?
0
 
LVL 7

Author Comment

by:JosephEricDavis
ID: 34947611
Yes, I opened up the database file and looked at it, but I don't understand how it is being done.
0
 
LVL 21
ID: 34947828
JosephEricDavis,

Do you like any of the examples? If you will let me know  which form you like in the example I will be glad to show the steps for adding it into your database.

0
 
LVL 7

Author Comment

by:JosephEricDavis
ID: 34951616
Ok, I think I got it figured out.  Thanks for the guidance.
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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

920 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

16 Experts available now in Live!

Get 1:1 Help Now