Dan Waters
dwaters at usinternet.com
Fri Sep 12 19:44:48 CDT 2008
The continuous form only shows one record at a time, and the formatting for the controls gets fairly complex. I'd like to avoid putting complicated text into conditional formatting fields, but instead trigger a reformat in code each time a different record is displayed. Conditional formatting will work here, but it's really time consuming and it has no compiler or run-time errors, so anything wrong will go undetected until try all your examples and just look at the screen. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Friday, September 12, 2008 7:17 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Trigger An Event by Changing Records in a Continuous Form? The OnCurrent event is triggered automatically when you move to another record. However, the scrollbar/mousewheel/pgdwn/pgup only affects the display, not the selected record, so it doesn't trigger OnCurrent. Can you explain more about what you're trying to do? Charltote Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, September 12, 2008 4:02 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Trigger An Event by Changing Records in a Continuous Form? On a continuous subform, I would like to trigger an event when a different record is viewed, either because the mouse wheel was used or because the scrollbar was used. Is there a way to do this? Somewhere an event is being triggered because conditional formatting will be used to reformat comboboxes and textboxes. Thanks! Dan -- 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