How to highlight a row in a detail section by selecting 1 field

[Access question]

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.

 

[Beetle]

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.

 

[Michael Gramelspacher]

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.

 

[Mike Painter]

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.