Highlight a row

  • Thread starter Thread starter Jonathan
  • Start date Start date
J

Jonathan

Hi, in MS Access 2003 I would like to hightlight an entire row in a
continuous subform so that it emulates a selected item in a listbox.

I have searched past posts to this group and the solution seems to be to add
a text box to the form. Then use conditional formatting where Expression IS
recordID=formVariable.

When I want to highlight a row, I set formVariable to match the current
recordID.

The conditional formatting works. The problem is that txtHighlight
hightlights every row in the continuous form.

This seems to be such a simple process, where am I going wrong?

Any ideas or suggestions appreciated :-)

Many thanks,
Jonathan
 
Jonathan said:
Hi, in MS Access 2003 I would like to hightlight an entire row in a
continuous subform so that it emulates a selected item in a listbox.

I have searched past posts to this group and the solution seems to be to add
a text box to the form. Then use conditional formatting where Expression IS
recordID=formVariable.

When I want to highlight a row, I set formVariable to match the current
recordID.

The conditional formatting works. The problem is that txtHighlight
hightlights every row in the continuous form.

This seems to be such a simple process, where am I going wrong?
Click to expand...


The devil's in the details ;-)

The "formVariable" must be a (hidden?) text box (in the
form's header or footer section).

The "recordID" needs to be a text box bound to the form's
record source table/query's primary key field.

The expression then needs to be in this syntax:
[recordID] = [formVariable]
and the [ ] are required.
 
Marshall Barton said:
Jonathan said:
Hi, in MS Access 2003 I would like to hightlight an entire row in a
continuous subform so that it emulates a selected item in a listbox.

I have searched past posts to this group and the solution seems to be to add
a text box to the form. Then use conditional formatting where Expression IS
recordID=formVariable.

When I want to highlight a row, I set formVariable to match the current
recordID.

The conditional formatting works. The problem is that txtHighlight
hightlights every row in the continuous form.

This seems to be such a simple process, where am I going wrong?
Click to expand...


The devil's in the details ;-)

The "formVariable" must be a (hidden?) text box (in the
form's header or footer section).

The "recordID" needs to be a text box bound to the form's
record source table/query's primary key field.

The expression then needs to be in this syntax:
[recordID] = [formVariable]
and the [ ] are required.
Click to expand...

Nice how it works when you follow ALL the instructions! <sigh>

Thanks friend,
Jonathan
 
Back
Top