Conditional formatting of detail section in an access form

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
 
T

Tom van Stiphout

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

Check out "Conditional Formatting" in the Help file.

-Tom.
Microsoft Access MVP
 
T

Tom van Stiphout

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top