Re: How can I change the color of the current record?

[John Spencer]

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.

"Sverk" <Sv...@discussions.microsoft.com> wrote in message
news:611DBF6E-2265-43DE...@microsoft.com...
> 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

[Sverk]

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:

[John Spencer]

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

"Sverk" <Sv...@discussions.microsoft.com> wrote in message

news:93C57640-72BB-467D...@microsoft.com...

[Sverk]

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:

[John Spencer]

Check out

http://www.lebans.com/conditionalformatting.htm

That has a sample database that you should be able to study and use to do
what you want.

"Sverk" <Sv...@discussions.microsoft.com> wrote in message

news:F4DFB90C-D8A3-4323...@microsoft.com...