Conditional formatting of detail section in an access form

[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

 

[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

 

[PBradac]

Hello Tom and thanks for your answer.

I've tried Help before but I couldn't find the answer.
In Help it's all about changing the formatting properties *of the
control based on its value*.

What I want is to change a formatting property of the whole details
section where the control is (based on the control's value of course).
E.g. if a text box shows a negative value I want the whole detail
section to show in red not just the text in the textbox.

It's simple to change the color of the details section in VBA, but
where do I have to put

Me.Section(acDetail).Backcolor = vbRed

so that it will be "executed" for the row where the textbox with
negative value is situated.

Primoz

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

Check out "Conditional Formatting" in the Help file.

-Tom.
Microsoft Access MVP

--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---

 

[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

 

[PBradac]

Tom,

not very happy :-(, but thanks anyway .

I was wondering if moving the focus through the records (and by it
through rows in datasheet) could somehow help. I'll give it a try.

Regards,
Primoz

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

--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---