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

changing field background colour on continous forms

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

Oct 2 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Try conditional format under the format menu.

Oct 2 '06 #2

P: n/a
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.
Oct 2 '06 #3

P: n/a
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
Oct 2 '06 #4

P: n/a
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
Oct 2 '06 #5

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

Oct 2 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.