Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-07-2008, 08:14 AM   #1
KenHigg
Registered User
 
Join Date: Jun 2004
Posts: 13,309
Thanks: 8
Thanked 155 Times in 129 Posts
KenHigg has a spectacular aura about KenHigg has a spectacular aura about
Highlight row

I have a subform displaying multiple rows and what I need is to have it when a user selects a row (by clicking on the row selector or otherwise), the entire row high-lights so that the data is easy to read as it goes accross - Any ideas?

Thanks,

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

ken

“You don’t learn to walk by following rules. You learn by doing, and by falling over.”
KenHigg is offline   Reply With Quote
Old 02-07-2008, 11:03 PM   #2
MarkK
Super Moderator
 
MarkK's Avatar
 
Join Date: Mar 2004
Location: Vancouver BC
Posts: 7,761
Thanks: 10
Thanked 1,290 Times in 1,227 Posts
MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all
Ken:
In a datasheet you can use this...
Code:
Private Sub Form_Current()
   DoCmd.RunCommand acCmdSelectRecord
End Sub
Mark
__________________
formerly known as lagbolt | Windows 10 | Access 2010 | Visual Studio 2013 | "Institutions have a vested interest in perpetuating the problems to which they are the solution." - Clay Shirky
MarkK is offline   Reply With Quote
Old 01-28-2010, 10:53 AM   #3
TomatoJo
Registered User
 
Join Date: Jan 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
TomatoJo is on a distinguished road
Re: Highlight row

I would like to do the same thing but I'm confused how to use this (I am using Access 97 but it also seems to work in 2003.) I have a subform and I would like to highlight the row that the user clicks into. Which section of the subform (OnLoad? OnOpen? etc.) do I enter this code? I tried it in OnLoad and it highlight the first row, but doesn't highlight the row that I next click.

TomatoJo is offline   Reply With Quote
Old 01-28-2010, 12:33 PM   #4
ghudson
Newly Registered User
 
ghudson's Avatar
 
Join Date: Jun 2002
Location: USA
Posts: 6,199
Thanks: 1
Thanked 87 Times in 49 Posts
ghudson has a spectacular aura about ghudson has a spectacular aura about ghudson has a spectacular aura about
Re: Highlight row

Try the on got focus event of each field that the user can click then use the DoCmd.RunCommand acCmdSelectRecord.
__________________
.................................................. ......
Searching this forum or Microsoft.com or MSDN.com or Google is a great way to discover and learn the answers to your Access programming questions.

Well if it seems to be real, it's illusion...

I am using Access 2010 with Windows 7

The
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
function on this forum really does work.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

.................................................. ......
ghudson is offline   Reply With Quote
Old 01-28-2010, 04:42 PM   #5
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,814
Thanks: 56
Thanked 1,028 Times in 994 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Highlight row

i dont think you can do this in a continuous form.

each row has the same formatting/display properties

__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlight selected row. lina2401 Forms 5 04-08-2011 05:30 PM
How to highlight the entire row or column with Default View "Continuous Forms"? danyeungw Forms 3 06-11-2007 07:47 PM
highlight a row in a table -automated using macro Hapr1 Macros 3 03-01-2006 06:57 AM
Highlight Row on Cont. SubForm With Mouse Move Evemt KevinM Forms 2 05-18-2005 02:33 AM
Highlight Selected Row in Tabular Form Cosmos75 Modules & VBA 9 07-18-2002 09:24 AM




All times are GMT -8. The time now is 01:38 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World