John Colby
jcolby at colbyconsulting.com
Fri Oct 17 08:07:25 CDT 2003
Jim, Is the OLE control something built in to Access? I tend to avoid (like the plague) having things that have to be registered by my app. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Dettman Sent: Friday, October 17, 2003 8:51 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Highligt Row in Continuous Form John, Yes, that would work as well, as would storing a bookmark. Both would be faster then the function code posted. The only drawback is that a requery invalidates positions and bookmarks, but that is not a major obstacle as long as your aware of it. The sample MDB I worked up has an example using bookmarks. You might want to take a look at the sample, as I use a slightly different technique (wish I could claim that I thought of it) to control row colors. The technique (use of a bound OLE control) not only allows for displaying of different colors, but graphics as well. Quite flexible. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Colby Sent: Thursday, October 16, 2003 9:14 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Highligt Row in Continuous Form I went in to look at the demo. It uses an entire function to get the current line number. In my framework I use .RecordsetClone.AbsolutePosition. Can anyone comment on whether this replaces the function? John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark Sent: Thursday, October 16, 2003 3:59 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Highligt Row in Continuous Form Changing the Background Color of the Current Record in a Continuous Form http://www.mvps.org/access/forms/frm0047.htm Mark -----Original Message----- From: Mark A Matte [mailto:markamatte at hotmail.com] Sent: Thursday, October 16, 2003 3:06 PM To: accessd at databaseadvisors.com Subject: [AccessD] Highligt Row in Continuous Form Hello All, In A97 on a continuous form...I want to highlight or identify the row that has focus. Change the color of something...anything...but only on that record? Is this possible? Everything I tried changed the color of every instance of that control...not just the one on the current record? Any Ideas? Thanks, Mark _________________________________________________________________ Enjoy MSN 8 patented spam control and more with MSN 8 Dial-up Internet Service. Try it FREE for one month! http://join.msn.com/?page=dept/dialup _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com