If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
change colors on selected record
I already check the existing threads and I could not find an answer to my
question. I have a continuous form with eleven columns. What I want to do is change the back/fore colors on all the fields for the selected record. At this time only a field changes color (Whatever the default is in the acces form). So If the user selects record 20, the entire record changes colors, when the user selects record 10, record 20 goes back to the original colors and record 10 changes colors, etc. Thanx. |
#2
|
|||
|
|||
On Fri, 5 Aug 2005 10:46:06 -0700, Ricoy-Chicago wrote:
I already check the existing threads and I could not find an answer to my question. I have a continuous form with eleven columns. What I want to do is change the back/fore colors on all the fields for the selected record. At this time only a field changes color (Whatever the default is in the acces form). So If the user selects record 20, the entire record changes colors, when the user selects record 10, record 20 goes back to the original colors and record 10 changes colors, etc. Thanx. Access 2002 or newer? See http://www.lebans.com specifically: http://www.lebans.com/conditionalformatting.htm You can down load a sample database that includes various uses for shaded lines, including continuous form alternating lines and highlighting the selected line. And also look at: http://www.lebans.com/alternatecolordetailsection.htm -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SET A SUBFORM TO PRINT ONLY SELECTED RECORD IN A FORM | BEE | Using Forms | 1 | June 15th, 2005 08:27 PM |
Access Mail Merge to Word.doc files ? | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 18th, 2005 06:31 PM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
How do I change the colors for an appointment in Outlook? | CIS101 | Calendar | 3 | November 2nd, 2004 02:53 AM |