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]

Re: changing field background colour on continous forms

Try conditional format under the format menu.

[kaisersose1995]

Re: changing field background colour on continous forms

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]

Re: changing field background colour on continous forms

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]

Re: changing field background colour on continous forms

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]

Re: changing field background colour on continous forms

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

William Hindman

"kaisersose1995 " <kaisersose1995 @hotmail.comwro te in message
news:1159803583 .519532.147500@ e3g2000cwe.goog legroups.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

>