Access 97 continuous forms

[Lee]

Hi all,
has anyone tried to programme continuous forms?

i have a continuous form with date fields on each record.
i want to be able to change the colour of the date text
depending on how old it is. that is not the problem.

how can i use the code on each individual record? it
seems to apply the colours to all records depending on the
values in the record selected.

any ideas?
many thanks,
lee.

 

[Van T. Dinh]

Sorry, not possible in A97.

In A2K and later, you can use the Conditional Format of the Control.

 

[Evan]

Not strictly true

You can fiddle it in a way.

Have a look at http://www.mvps.org/access/forms/frm0024.htm

HTH

 

[Van T. Dinh]

Lee actually asked for the Foreground colour, NOT Background.

Have you tried using a similar method for Foreground?