Continuous form query

  • Thread starter Thread starter Russell Farr
  • Start date Start date
R

Russell Farr

I have a continuous form which displays a list of tasks.
Some of these tasks are marked urgent, and there is a
checkbox to illustrate this.

What I'd like to do, is highlight the urgent tasks by
marking them in red somehow, either by marking the
background for that particular record as red, or all the
text in each field as red. I'm trying to use the
following simple code:

If Me.Flag = True Then
Me.Task.ForeColor = 255
End If

This doesn't appear to work though.

Is it possible to isolate an individual record in a
continuous form and mark it differently?

Thanks

Russell
 
Hi Russell,

If you are using A2k or higher check out Conditional Format in the help
file. If you are using A97 I believe there may be some method on Stephen
Lebans website, but I'm not sure. www.lebans.com

HTH
Steve C
 
Russell said:
I have a continuous form which displays a list of tasks.
Some of these tasks are marked urgent, and there is a
checkbox to illustrate this.

What I'd like to do, is highlight the urgent tasks by
marking them in red somehow, either by marking the
background for that particular record as red, or all the
text in each field as red. I'm trying to use the
following simple code:

If Me.Flag = True Then
Me.Task.ForeColor = 255
End If

This doesn't appear to work though.

Is it possible to isolate an individual record in a
continuous form and mark it differently?
Click to expand...

In A2K+, you can use Conditional Formatting to do that.
It's trickier in A97-.
 
Back
Top