Conditional formatting of detail section in an access form

  • Thread starter Thread starter PBradac
  • Start date Start date
P

PBradac

I'm stuck in the following problem:

- Access 2003
- Form in datasheet view (tabular form)
- Want to format (change the background color of) details section
based on a value of a text box contained in it using VBA
- Can't find where to put a statement like:
Me.Section(acDetail).Backcolor = vbWhite
so that the background would be colored correspondingly.
The coloration appears only when the condition is met on the first
record (row) shown and it spreads over all records (rows)

I want to have the right color in those rows only where the condition
is met.

TIA for help
 
On Thu, 21 Jan 2010 13:05:19 +0100, PBradac

Check out "Conditional Formatting" in the Help file.

-Tom.
Microsoft Access MVP
 
On Thu, 21 Jan 2010 15:11:15 +0100, PBradac

I see the dilemma now. You can set conditional formatting to controls,
not to the Details section itself. Perhaps that suffices though.

-Tom.
Microsoft Access MVP
 
Back
Top