I have an integer, e.g. 240. I convert it to a variant in hh:mm format, e.g," 4:00". I then save this in a field in my table which is formatted as a string.
My report (based on my table) displays the value "4:00" in the report field. So far, so good.
I was hoping to do some conditional formatting in my report along the lines "Anything < "4:00" needs to be displayed in red." Unfortunately, it doesn't appear I can do conditional formatting on a string. Any one have any suggestions? The bottom line is to display the as "hh:mm" and utilize conditional formating.
Thanks!
Ken
My report (based on my table) displays the value "4:00" in the report field. So far, so good.
I was hoping to do some conditional formatting in my report along the lines "Anything < "4:00" needs to be displayed in red." Unfortunately, it doesn't appear I can do conditional formatting on a string. Any one have any suggestions? The bottom line is to display the as "hh:mm" and utilize conditional formating.
Thanks!
Ken