Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 13th, 2007, 03:37 AM
Authorized User
Join Date: Jun 2007
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Highlight complete record line


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
Old August 13th, 2007, 12:13 PM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

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?


Old August 14th, 2007, 04:43 AM
Authorized User
Join Date: Jun 2007
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
next record "line" of a database table jofoxy2000 Access VBA 0 April 1st, 2008 01:39 PM
How to draw indicator line in owc line chart AlexOo General .NET 0 July 9th, 2007 10:32 PM
How to read file line by line in EVC++ iriskab Visual C++ 0 September 27th, 2006 01:39 PM
Reading line by line from a .txt file x_ray VB.NET 2002/2003 Basics 5 February 10th, 2006 01:55 PM
Highlight record JpJoe Access 4 January 28th, 2005 09:58 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.