Background colour in Continuous forms

[Hans Karman]

Is it possible to set the background colour for each record in a continuous
form to the colour stored in a datafield within that record?

Hans Karman, Canberra, Australia

[MacDermott]

The only way I know of to apply different formatting to different records in
a continuous form is to use conditional formatting. That, in turn, applies
only to textboxes, not to the form (or detail section itself).
So the quick answer is no, you can't do that per se.
A work-around, though, might be to put a locked textbox behind the entire
record, and use conditional formatting on that.
On second thought, you might want to disable it, too; if you don't, then
clicking on it - even accidentally- will bring it to the fore and obscure
everything else in the section.

HTH

"Hans Karman" <ha**@karman.au.com> wrote in message
news:41******@news.comindico.com.au...

Is it possible to set the background colour for each record in a continuous form to the colour stored in a datafield within that record?

Hans Karman, Canberra, Australia

[Hans Karman]

In what event does one put this conditional formatting? I've tried "on
current" but that had a bad effect on performance.

Hasn Karman, Canberra, Australia

"MacDermott" <ma********@nospam.com> wrote in message
news:Hs****************@newsread3.news.atl.earthli nk.net...

The only way I know of to apply different formatting to different records in a continuous form is to use conditional formatting. That, in turn, applies only to textboxes, not to the form (or detail section itself).
So the quick answer is no, you can't do that per se.
A work-around, though, might be to put a locked textbox behind the entire
record, and use conditional formatting on that.
On second thought, you might want to disable it, too; if you don't, then
clicking on it - even accidentally- will bring it to the fore and obscure
everything else in the section.

HTH

"Hans Karman" <ha**@karman.au.com> wrote in message
news:41******@news.comindico.com.au...

Is it possible to set the background colour for each record in a

continuous

form to the colour stored in a datafield within that record?

Hans Karman, Canberra, Australia

[MacDermott]

Conditional formatting is applied to a control in Design View -
select the textbox, then on the menu click Format and Conditional
Formatting.

HTH
- Turtle

"Hans Karman" <ha**@karman.au.com> wrote in message
news:41******@news.comindico.com.au...

In what event does one put this conditional formatting? I've tried "on
current" but that had a bad effect on performance.

Hasn Karman, Canberra, Australia

"MacDermott" <ma********@nospam.com> wrote in message
news:Hs****************@newsread3.news.atl.earthli nk.net...

The only way I know of to apply different formatting to different records

in

a continuous form is to use conditional formatting. That, in turn,

applies

only to textboxes, not to the form (or detail section itself).
So the quick answer is no, you can't do that per se.
A work-around, though, might be to put a locked textbox behind the

entire record, and use conditional formatting on that.
On second thought, you might want to disable it, too; if you don't, then clicking on it - even accidentally- will bring it to the fore and obscure everything else in the section.

HTH

"Hans Karman" <ha**@karman.au.com> wrote in message
news:41******@news.comindico.com.au...

Is it possible to set the background colour for each record in a

continuous

form to the colour stored in a datafield within that record?

Hans Karman, Canberra, Australia