Highlight row

[KenHigg]

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]

Ken:
In a datasheet you can use this...

Private Sub Form_Current()
   DoCmd.RunCommand acCmdSelectRecord
End Sub

Mark

 

[TomatoJo]

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]

Try the on got focus event of each field that the user can click then use the DoCmd.RunCommand acCmdSelectRecord.

 

[gemma-the-husky]

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

each row has the same formatting/display properties