Continuous Form: Changing .BackColor depending on value?

[PeteCresswell]

Users want negative values to have a yellow background.

No problem on the subforms where every value is a discreet field,
but I can't figure out how to make it happen on a continuous form
where a given field can show many values depending on row.

My kneejerk is making the field's .BackStyle=Transparent and laying it
over top of another field in which I do some sort of workaround with
the numeric .Format thing's color option - but I can't make it
happen.

[Trevor Best]

PeteCresswell wrote:

Users want negative values to have a yellow background.

No problem on the subforms where every value is a discreet field,
but I can't figure out how to make it happen on a continuous form
where a given field can show many values depending on row.

My kneejerk is making the field's .BackStyle=Transparent and laying it
over top of another field in which I do some sort of workaround with
the numeric .Format thing's color option - but I can't make it
happen.

There's conditional formatting, I haven't looked at that but I suspect
it's limited to foreground color (I may be wrong).

The workaround is to make the textbox transparent, and another textbox
overlayed (but sent to back) with a control source:

=IIf([MyTextBox]<0,String(30,"g"),"")

Set front to Webdings and very large, set foreground color of that
textbox to whatever you want the background to be.

[PC Datasheet]

You need Access2000 or later to use conditional formatting. Conditional
formatting can conditionally set backcolor, forecolor or both (as well as
bold, italic and underline). If your app is A2000 or later, this is what you
need to use.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Trevor Best" <no****@localhost.invalid> wrote in message
news:43***********************@news.zen.co.uk...

PeteCresswell wrote:

Users want negative values to have a yellow background.

No problem on the subforms where every value is a discreet field,
but I can't figure out how to make it happen on a continuous form
where a given field can show many values depending on row.

My kneejerk is making the field's .BackStyle=Transparent and laying it
over top of another field in which I do some sort of workaround with
the numeric .Format thing's color option - but I can't make it
happen.

There's conditional formatting, I haven't looked at that but I suspect
it's limited to foreground color (I may be wrong).

The workaround is to make the textbox transparent, and another textbox
overlayed (but sent to back) with a control source:

=IIf([MyTextBox]<0,String(30,"g"),"")

Set front to Webdings and very large, set foreground color of that textbox
to whatever you want the background to be.

[(PeteCresswell)]

Per Trevor Best:

There's conditional formatting,

Bingo!

I apologize too. Sometime last year someone posted that very answer to the
same question.
--
PeteCresswell