Provide conditional formatting features to datasheets and continuous forms
As per Excel, it would be great to highlight and distinguish field data between the records displayed. Currently, if a format is set on a field, in a continuous form, the entire column receives that format, whether or not the data value contained, matches the criteria.

3 comments
-
Sascha Trowitzsch commented
BTW: Many ActiveX-Grids support such a feature! Why not provide it to Access datasheets? The individual formatting already is internally built in!
-
Sascha Trowitzsch commented
@Shane: Yes, that's the only way you can achieve it. But it is a horror pain to attach all these conditional expressions to data sources with many columns. Sometimes it is simply not possible to highlight a single cell by using a a format conditon which has to depend on a field value. The only way would be to alter a format expression at runtime via VBA.
So it would really be nice to have a methode or property to influence the format of a datasheet or continous form control. E.g.Me.Recordset.Move 5
Me.Controls("txt7").BackColorSingle = RGB (255,200,200)This only should format the seventh Textbox in the 6th record.
-
It's true that applying formatting to a field in a continuous form or a column in a datasheet applies to the control in every row, but that is not true for conditional formatting. If you set background color, for example, to a different color based on a value, it applies to the controls only in those records that match the criteria. Am I misunderstanding what you are asking for?