By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Background colour in Continuous forms

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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


Nov 13 '05 #3

P: n/a
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



Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.