Goodday,

I have created a form and if you have the form in "Datasheet" mode and you select a record it highlights all details also black. Now I want the same when it is in Continuous Forms.

I now have only 1 field. On mouse over event Me.Id.Backcolor = 16777215

So my question is...

On what event Should I do it? What is the name for setting an event on the current record?

Can somebody put me in the right direction please?

Thank you in advance

Basically you want this code on each controls' On Got Focus event. I don't think you would use it on the form's On Current Event. You would have to set and remove highlighting with this event.

The problem with this is that you will also have to do this to REMOVE highlighting for the record.

You may have to create a public variable to hold a RecordNumber, and then highlight and unhighlight based on the recordnumber.

Why do you need this functionality, if you don't mind asking?

HTH

mmcdonal

Basicly i made an list with an overview of current projects. All fields are locked accept the "edit" field. I made it that you can click in the current record where you want and the "edit project" form pops-up with the record you selected. Then I made an mouse over event so a little hand appears so a user knows he can click where ever he wants. Now I thought it would be nice to highlight the complete line so you can read better and offcourse it looks better.

I actually wanted it under the mouse over event, but the problem is that this event can not recognize a seperated record. It highlights the copmplete detail section and that is not good :D I now know it has to go under the single click and then select the item on double click. And i also think it would be better to merge all details into 1 field so you only have 1 field to control instead of the 8 i have now. Maybe something for another time.

But it has to be done friday, so i guess it will not make the app after all.

I tried to be quick and simple but it turns out harder then i expected. To bad i have no time to figure it out.

Thank you for input anyway