Highlighting individual records on a continuous form

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi,

I have a form that displays jobs and the time that is left before the job
runs over.
there is a timer on the form that runs every minute to update the time
remaining for each job
i want to put a check on the timer event that will highlight a job that has
gone over its alloted time

ie

if me.txtTimeRemaining < 0 then

me.txtJobNumber.ForeColor = vbRed

Else

me.txtJobNumber.ForeColor = vbRed

end if


however all this does is check the first record and then colours all records
the same.

how can i achieve the effect i want?

thanks
Dave
 
Dave,

You could try using a conditional format instead.

For example to highlight the job, click on the job control
in design view and go to conditonal format
pick 'Expression is' and enter [Time]="00:00:00" and
choose a format.

Charlie O'Neill
 
Charlie,

Thanks,
that works great

Dave


Charlie said:
Dave,

You could try using a conditional format instead.

For example to highlight the job, click on the job control
in design view and go to conditonal format
pick 'Expression is' and enter [Time]="00:00:00" and
choose a format.

Charlie O'Neill
-----Original Message-----
Hi,

I have a form that displays jobs and the time that is left before the job
runs over.
there is a timer on the form that runs every minute to update the time
remaining for each job
i want to put a check on the timer event that will highlight a job that has
gone over its alloted time

ie

if me.txtTimeRemaining < 0 then

me.txtJobNumber.ForeColor = vbRed

Else

me.txtJobNumber.ForeColor = vbRed

end if


however all this does is check the first record and then colours all records
the same.

how can i achieve the effect i want?

thanks
Dave


.
Click to expand...
Click to expand...
 
Back
Top