Highlight a row

[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

 

[Marshall Barton]

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?

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.

 

[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?

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.

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

Thanks friend,
Jonathan