Create a visual cue on a continuous form

[Pete]

Re Access 2003.

I have a form with two continuous subforms:
1 - user account info (master)
2 - show additional regions assigned to selected user (child)

As the user selects a record on subform 1, the data updates on 2 accordingly.

Subform 1 has Record Selectors set to 'no'. I would like to create a visual
cue as to which record is selected on subform 1 (something more prominent
than just the flashing cursor in one of the text boxes).

Is this possible without using Record Selectors?
Many thanks.

 

[Stuart McCall]

Re Access 2003.

I have a form with two continuous subforms:
1 - user account info (master)
2 - show additional regions assigned to selected user (child)

As the user selects a record on subform 1, the data updates on 2
accordingly.

Subform 1 has Record Selectors set to 'no'. I would like to create a
visual
cue as to which record is selected on subform 1 (something more prominent
than just the flashing cursor in one of the text boxes).

Is this possible without using Record Selectors?
Many thanks.

Well you could use conditional formatting to change the backcolor of the
active control. Just use the condition 'Field has Focus' and pick your
colour.

 

[Pete]

That works very well. Thanks.

There is one small caveat; the first record displays the formatting (as it
has the focus) but when I move to another record, the first record keeps a
white border around it. All the other records return to normal format.

Any ideas why this happens only on the first (top) record?
Many thanks.

 

[Pete]

Apologies. This doesn't quite work.

Only the control on the current row does indeed highlight, but reverts back
when I then edit the child subform (2), ie, subform 1 loses the focus.

If possible, I would like just the control on the selected row on subform 1
to stay highlighted whilst editing subform 2.

many thanks.

 

[Stuart McCall]

That works very well. Thanks.

There is one small caveat; the first record displays the formatting (as it
has the focus) but when I move to another record, the first record keeps a
white border around it. All the other records return to normal format.

Any ideas why this happens only on the first (top) record?
Many thanks.

At this point I don't have a clue.When you move from record 2 to record 3,
does the same effect occur?
<snip>

 

[Michael Gramelspacher]

Apologies. This doesn't quite work.

Only the control on the current row does indeed highlight, but reverts back
when I then edit the child subform (2), ie, subform 1 loses the focus.

If possible, I would like just the control on the selected row on subform 1
to stay highlighted whilst editing subform 2.

many thanks.

I think this example does what you want.
http://www.psci.net/gramelsp/temp/Subform_Example2.zip

It uses conditional formating.