vba - Application.ScreenUpdating in Access -

i trying disable screenupdating 1 of columns keeping update according active row in access report. trying print out row row condition, changing every row condition instead of changing whole column condition.

conditions follows:

• green duration:0 -20
• orange duration: 20 - 60
• red duration: 60+

my question why such issue happening? when trying print preview, conditional formatting doesn't work.

i have tried both application.screenupdating = false , application.echo = false. application.screenupdating seems not exist in access , application.echo seems jam forms.

i unable upload screenshot since work pc not allow uploading, elaborate more here:

• the whole duration column changes color while scrolling in report
• report re-updates conditions while scrolling
• print preview prints without conditions.

please let me know if require more info! help!

added info:

i using conditional formatting format seperate cells according conditions said.

here vba code i'm using..

private sub detail_paint()  teststring = me.duration1.value  dim testarray() string  testarray = split(teststring, ":")  dim hours string dim minutes string dim seconds string  dim hoursminutes integer dim minutesminutes integer dim secondsminutes integer  hoursminutes = cint(testarray(0)) * 60 minutesminutes = cint(testarray(1)) secondsminutes = cint(testarray(2)) / 60   dim timeinminutes integer  timeinminutes = hoursminutes + minutesminutes + secondsminutes  me.duration.value = timeinminutes   end sub 

i noticed when exporting file excel /pdf , duration not appear..