Question Time Fields and Conditional Formatting (1 Viewer)

[Chelle1661]

I have tried to change the colour of the text in time fields with no a value of 0:00 by using conditional formatting - to no avail. Is there anyone who can help with this?

 

[PaulO]

Rather than "0:00" which won't ever be recognised as a Time format, try "00:00:00" or "00:00" (depending on the exact format for the field)

 

[Chelle1661]

Hi Paul,
Thanks for your reply.
I have the format in the back end table as 00:00:00 and then in the report this expression to convert total minutes to hours :
=[TotalMinutes]\60 & Format([TotalMinutes] Mod 60,"\:00")
I have managed to get the conditional formatting to work on all other time related fields except this one.

 

[PaulO]

ok ... what Conditional Format statement have you used?

 

[Chelle1661]

I have tried Field Value "less than or equal to and less than" 00:00:00 and 0.00 [latter being how the value looks in the report field]. Also tried Expression Is with above time format and got an error message about Invalid Syntax with both attempts..