Highlight Selected Record

  • Thread starter Thread starter Karen Hagerman
  • Start date Start date
K

Karen Hagerman

Does anyone know how to access the 'RecordSelector' on a form.

I have a continuous form and would like to change the background to a different color when the record is selected.

Karen
 
Wayne,

Thank you. I still have to try them but it looks like the first one is exactly what I want. I also appreciate the sources.

Karen
Based on your request, I think you'll find the following helpful. I tried to place them in the order I think they best answer your question. They don't all do exactly what you ask, but have some similar functionality.

http://www.mvps.org/access/forms/frm0047.htm
http://www.mvps.org/access/forms/frm0024.htm
http://www.lebans.com/alternatecolordetailsection.htm

--
Wayne Morgan
Microsoft Access MVP


Does anyone know how to access the 'RecordSelector' on a form.

I have a continuous form and would like to change the background to a different color when the record is selected.

Karen
 
Wayne if the OP is using A2K or later then I would suggest using
ConditionalFormatting. Sample code is here:
http://www.lebans.com/conditionalformatting.htm
A2K or Higher Only!

New Feb 08,2002. Added support for Datasheet view and SubForms.

A2KConditionalFormatting.zip is a sample MDB demonstrating how to
programmatically setup Conditional Formatting to simulate:

1) Highlighting of the Current Row for a Form in Continuous or Datasheet
View

2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet
View

Version 2.7

Added sample demonstrating how to achieve a background
Hover/Highlighting of rows for a form in Continuous view.

Version 2.3

Added sample demonstrating how to achieve pseudo enable/disable of an
unbound control on a form in Continuous View.

Version 1.9

Added sample form to show how to apply conditional formatting to based
on a Boolean(Yes/No) field.

Verrsion 1.8

Starting to cleanup code and add comments!

Version 1.4

First release


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


message Based on your request, I think you'll find the following helpful. I
tried to place them in the order I think they best answer your question.
They don't all do exactly what you ask, but have some similar
functionality.

http://www.mvps.org/access/forms/frm0047.htm
http://www.mvps.org/access/forms/frm0024.htm
http://www.lebans.com/alternatecolordetailsection.htm

--
Wayne Morgan
Microsoft Access MVP


Does anyone know how to access the 'RecordSelector' on a form.

I have a continuous form and would like to change the background to a
different color when the record is selected.

Karen
 
Not sure what you are talking about here Karen. THe MDB you mentioned,
AlternateColorDetailSection does not contain the Form you referenced.
The A2KConditionalFormatting MDB does contain the referenced Form.
Further the form's Class module does contain comments that explain the
operation of the CF.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Stephen,

I finally figured it out. I had to have autonumber field on the first
textbox, customerid, everything works. Thanks for having this option
available on your website!

Karen Hagerman
 
Back
Top