changing field background colour on continous forms

[kaisersose1995]

Hi,
I am trying to add some visual confirmation to a continous form, to let
the user know if a stored date on the form has passed. I have managed
to set the background colour using a simple IF statement comparing the
stored date with the Date() control and the .backcolour vb control.
however once the background colour of the field has been set, it sets
the colour for every line on the form. Is there anyway of making just
specific cells on specific lines turn a different colour?

thanks in advance

Richard

[Svetlana]

Try conditional format under the format menu.

[kaisersose1995]

i can't find any option for Conditional format? where is this located,
in the properties box?

thanks

Richard

Svetlana wrote:

Try conditional format under the format menu.

[fredg]

On 2 Oct 2006 06:31:19 -0700, kaisersose1995 wrote:

i can't find any option for Conditional format? where is this located,
in the properties box?

thanks

Richard

Svetlana wrote:

>Try conditional format under the format menu.

It's not located on the properties box, in on the Format menu.
In Form design view, select the control you wish to conditionally
format.
Then click on the menu Format + Conditional Formatting.
This is only available from Access 2000 and newer.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[kaisersose1995]

ah right, that'll be the reason then, we're still using 97 as the "guys
upstairs" won't give us the budget to upgrade....i guess i'll have to
try another way, thanks anyway though

Rich
fredg wrote:

On 2 Oct 2006 06:31:19 -0700, kaisersose1995 wrote:

i can't find any option for Conditional format? where is this located,
in the properties box?

thanks

Richard

Svetlana wrote:

Try conditional format under the format menu.

It's not located on the properties box, in on the Format menu.
In Form design view, select the control you wish to conditionally
format.
Then click on the menu Format + Conditional Formatting.
This is only available from Access 2000 and newer.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[William Hindman]

....in that case, see www.lebans.com ...he has workaround for earlier
versions.

William Hindman

"kaisersose1995" <ka************@hotmail.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...

ah right, that'll be the reason then, we're still using 97 as the "guys
upstairs" won't give us the budget to upgrade....i guess i'll have to
try another way, thanks anyway though

Rich
fredg wrote:

>On 2 Oct 2006 06:31:19 -0700, kaisersose1995 wrote:

i can't find any option for Conditional format? where is this located,
in the properties box?

thanks

Richard

Svetlana wrote:
Try conditional format under the format menu.

It's not located on the properties box, in on the Format menu.
In Form design view, select the control you wish to conditionally
format.
Then click on the menu Format + Conditional Formatting.
This is only available from Access 2000 and newer.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail