Conditional Formating

[CF via AccessMonster.com]

I have a continuous form with five text box controls. I would like to
conditional format four of the five text boxes and be based on the first
text box. The first text box will contain an integer value between 1 and
6. As you know using the command under Format->Conditional Formatting only
allows for up to three different conditions. Is there a way to use a
Private function to conditional format that will save me any time?

When I currently use a function, the formatting I base off an "IF"
Statement takes the first records conditions and formats that record as
well as the other records in the Continuous form. I have done a little
research and found a way to format a continous form on www.mvps.org, but at
this time I can not take any more time for this section (In a future
version I plan on it)

Thanks for the help in advance
CF

 

[Marshall Barton]

I have a continuous form with five text box controls. I would like to
conditional format four of the five text boxes and be based on the first
text box. The first text box will contain an integer value between 1 and
6. As you know using the command under Format->Conditional Formatting only
allows for up to three different conditions. Is there a way to use a
Private function to conditional format that will save me any time?

When I currently use a function, the formatting I base off an "IF"
Statement takes the first records conditions and formats that record as
well as the other records in the Continuous form. I have done a little
research and found a way to format a continous form on www.mvps.org, but at
this time I can not take any more time for this section (In a future
version I plan on it)

Be careful of your terminology here. CF conditions can be
expressions (that can include a function) so you can test
for many "conditions".

I suspect that you are talking about the limit on the number
of different "formats" that can be specified. You can have,
counting the default format, four different formats. That
is a hard limit in CF.

Overlaying multiple text boxes as suggested in the article
is the way to go beyond that limit, but it can start to slow
things down when you apply too many conditions.

Using VBA to set the formatting properties of a control on a
continuous form is not going to produce the desired effect.