Highlight the Current

Hi,

Is there a a way to highlight the current on a Datasheet form?

I use the "On Current" Event to open another form, I would like to
"highlight" some how the current record.

Thank you all,

Bre-x

Are you talking about highligting the control that currently has the focus?
If you are I've always wanted to know if there was an easy way to do this.

Only way I know of to do this is to put some code in EACH control's On Got
Focus and On Lost Focus events to change something about the control (change
its backcolor/forecolor/borderwidth etc).

But this quickly gets very laborous if you try to keep a consistent
look/feel on each form, especially if you are working on a large database and
even if you make public procedures to put the 'highlight' into effect, you
still have to stick a call to those procedures in every single control's On
Got Focus/On Lost Focus events.

On large databases, it isn't worth the effort.

"Bre-x" wrote:

Hi,

Is there a a way to highlight the current on a Datasheet form?

I use the "On Current" Event to open another form, I would like to
"highlight" some how the current record.

Thank you all,

Bre-x

As Crazy has said, there is no easy way to do this. Lebans has a hack for
highlighting every other row, which you might be able to modify for your
needs. But to be honest, it would entail more work than I'd ever want to do,
for such a payoff.

As to Crazy's question about highlighting the control with focus, that's easy!


In Design View, select the control in question. Now

Goto Format - Conditional Formatting

In the Condition dropdown box select "Field has focus"

Now change to back color to whatever you want.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200902/1

Thank you all for your comments

Bre-x

"Bre-x" wrote in message
...
Hi,

Is there a a way to highlight the current on a Datasheet form?

I use the "On Current" Event to open another form, I would like to
"highlight" some how the current record.

Thank you all,

Bre-x