Highlight row (1 Viewer)

KenHigg

Registered User
Joined
Jun 9, 2004
Messages
13,309
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,
 

MarkK

Super Moderator
Joined
Mar 17, 2004
Messages
7,761
Ken:
In a datasheet you can use this...
Code:
Private Sub Form_Current()
   DoCmd.RunCommand acCmdSelectRecord
End Sub
Mark
 

TomatoJo

New member
Joined
Jan 28, 2010
Messages
1
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.
 

ghudson

Registered User
Joined
Jun 8, 2002
Messages
6,199
Try the on got focus event of each field that the user can click then use the DoCmd.RunCommand acCmdSelectRecord.
 

gemma-the-husky

Super Moderator
Staff member
Joined
Sep 12, 2006
Messages
13,873
i dont think you can do this in a continuous form.

each row has the same formatting/display properties
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom