How to highlight a row in a detail section by selecting 1 field Access question 12/4/2008 4:11:01 PM I am trying to highlight a single row in a detail section of a form when the user selects one of 10 different fields. Does anyone have a clear cut way to do this? I've downloaded some code, however, it seems too cumbersome. I have tried using a macro, however this does not work too well since I can only use the gotocontrol once. I am using Access 2003. I'm not too well versed in code...but can get by.

RE: How to highlight a row in a detail section by selecting 1 field Beetle 12/4/2008 5:51:01 PM There is not really a simple, built in way to highlight a row in a continuous form. Here are a couple of links with ways to do it programmatically, which you may or may not have already tried; http://www.lebans.com/conditionalformatting.htm http://www.mvps.org/access/forms/frm0047.htm Alternatively, if you can get by with just highlighting the back/fore color of a particular control (text box, etc.), you can do that rather easily with conditional formatting. -- _________ Sean Bailey "Access question" wrote: [Quoted Text] > I am trying to highlight a single row in a detail section of a form when the > user selects one of 10 different fields. Does anyone have a clear cut way to > do this? I've downloaded some code, however, it seems too cumbersome. I > have tried using a macro, however this does not work too well since I can > only use the gotocontrol once. I am using Access 2003. I'm not too well > versed in code...but can get by. > >

Re: How to highlight a row in a detail section by selecting 1 field Michael Gramelspacher <gramelsp[ at ]psci.net> 12/4/2008 7:26:56 PM On Thu, 4 Dec 2008 08:11:01 -0800, Access question <Accessquestion[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I am trying to highlight a single row in a detail section of a form when the >user selects one of 10 different fields. Does anyone have a clear cut way to >do this? I've downloaded some code, however, it seems too cumbersome. I >have tried using a macro, however this does not work too well since I can >only use the gotocontrol once. I am using Access 2003. I'm not too well >versed in code...but can get by. > Here is another example. http://www.helenfeddema.com/access.htm See # 173.

Re: How to highlight a row in a detail section by selecting 1 field "Mike Painter" <mddotpainter[ at ]sbcglobal.net> 12/4/2008 7:37:14 PM Access question wrote: [Quoted Text] > I am trying to highlight a single row in a detail section of a form > when the user selects one of 10 different fields. Does anyone have a > clear cut way to do this? I've downloaded some code, however, it > seems too cumbersome. I have tried using a macro, however this does > not work too well since I can only use the gotocontrol once. I am > using Access 2003. I'm not too well versed in code...but can get by. Where are these fields located? I'm guessing they are fields on the row itself and conditional formatting should work. While it depends on your user base a better solution might be to show them how to highlight the row themselves so they can apply it at any time.