[AccessD] Conditional Formatting - Current Record

Thanks A.D. - I think that ranking scheme will work. 

Regards,

Rocky



 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.TEJPAL
Sent: Monday, November 12, 2007 11:14 AM
To: Access Developers discussion and problem solving
Cc: A.D.TEJPAL
Subject: Re: [AccessD] Conditional Formatting - Current Record

Rocky,

    My sample db's mentioned below, might be of interest to you.

    (a) Form_SubformHighLightCurrentRow
    (b) HighLightDataSheetRows
    (c) ContFormsKeyNavAndHighLightMultiSelect
    (d) Form_HighLightUpdatedFields

    These are available at Rogers Access Library (other developers library).
Link - http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.
 
    You could adapt the underlying approach suitably, for your specific
needs.
 
Best wishes,
A.D.Tejpal
------------

  ----- Original Message -----
  From: Rocky Smolin at Beach Access Software
  To: 'Access Developers discussion and problem solving' 
  Sent: Monday, November 12, 2007 21:23
  Subject: Re: [AccessD] Conditional Formatting - Current Record


  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

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