Help With Conditional Formatting

  • Thread starter Thread starter Ash
  • Start date Start date
A

Ash

Hi All

I am using Access2k on Win2k and i have a continous subform which displays
records based on the criteria on the main form. I want to to be able to
highlight a field in the subform when its double clicked, it would be even
better if i could highlight which field the mouse pointer is hovering over
before its clicked but changing the border color will do. At the moment
when i set the border color property to a different color it changes the
entire column which is not what i want.

i understand that Conditional Formatting is what i need to use but i need
help with what i should do with it.

Any Help would be greatly appreciated

Ash
 
Samples to solves both issues using CF can be found here:
http://www.lebans.com/conditionalformatting.htm
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.

--

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