How can I change the color of the current record?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On a columnar form, showing 4-5 records at a time, I would like to have a
stronger indication of which one that is the current record -- the little
triangle in the left column is too small and in-conspicuous.
Best thing would be if the current record would show in a different
background color, or at least that one object in the record turned to a
different color.
Changing a color in design mode will apply to all records, right?, so that
won't work.
I guess it is possible to use some event, e.g. LostFocus, to detect when the
current record changes, but how can I make a property change that applies to
just one of the records showing on the form?
Please help,
Sverk
 
I believe you are talking about a continuous form.

If you have Access 2000 or later you can use conditional formatting to
change the background of the control when it gets the focus. In a
continuous form that only changes the control in the current record.
 
Thanks!
Using Access 2002, so that seems promising.
The form I am thinking of was created with the Form Wizard, which after
selection of fields gives a choice of layout. The one I chose was "Columnar"
-- "Continous" was not an option.
Am I right guessing that Columnar is one variety of continuous form layouts,
so that your suggestion will work?
Sverk

"John Spencer" skrev:
 
No columnar is not a continuous form. A continuous form shows many records
at one time and you can scroll up and down through the records. If you are
using the wizard, a choice that makes a continuous form is "Tabular:"

That aside, conditional formatting will work to show you which field has the
focus.
-- Select the control (or controls)
-- Select Format: Conditional Formatting from the menu
-- Select Field Has Focus as the condition
-- Click on the paint bucket (Fill/Back Color) and choose a color for
highlighting
-- Click OK
 
Well, both Tabular and Columnar work as you describe, good, but this way
highlighting can only be made for fields, and what I would want further is
that the whole CurrentRecord, or the record background, would be highlighted.
Conditional Formatting is not available (grayed) unless a field is selected.
Could it somehow be made in code instead?
Or, could I make the whole record area a control (frame?), with conditional
highlighting, and put all the current fields within it?
Sverk

"John Spencer" skrev:
 
Back
Top