Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Mon Nov 12 09:53:10 CST 2007
Dan: It doesn't work because the field never gets the focus. I did this on another app and the way I did it was to put a text box on the detail section, move to back and change the color of the text box when the record got the focus. There's no conditional formatting of the detail section. I was able to do this in an expression by comparing the Autonumber ID of the current record with an invisible text box in the header section. But it was a simple bound form with no subforms. That won't work in this case - the subform data is coming from another table. There must be some trick to telling the conditional formatting to operate on the current record only. Thanks and regards, Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, November 12, 2007 7:29 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Conditional Formatting - Current Record Rocky, In design view, the select the text box or combobox. Go to conditional formatting. Select 'Field has Focus'. Select your background color. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Monday, November 12, 2007 9:12 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Conditional Formatting - Current Record Dear List: I am trying to use conditional formatting to change the background color of a control when it is the current record. Control is actually on a sub-form but I don't think that's relevant. What is the expression I need in the conditional formatting dialog box to do this? MTIA Rocky -- 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 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.30/1125 - Release Date: 11/11/2007 9:50 PM