Solved Conditional Formatting Expression Data Format Error (1 Viewer)

Kayleigh

Member
Local time
Today, 00:06
Joined
Sep 24, 2020
Messages
706
Hi
I have just encountered an issue that have not found previously.
When designing conditional formatting rules for date fields it would change the expression to date format even though I input as regular integer. I tried a couple of times and this was result.
See attached screenshot.
 

Attachments

  • Screenshot 2022-05-03 160813.png
    Screenshot 2022-05-03 160813.png
    12.9 KB · Views: 163
  • Screenshot 2022-05-03 160911.png
    Screenshot 2022-05-03 160911.png
    12.7 KB · Views: 152

cheekybuddha

AWF VIP
Local time
Today, 00:06
Joined
Jul 21, 2014
Messages
2,237
Try placing a equals sign at the beginning of your expression
 

Kayleigh

Member
Local time
Today, 00:06
Joined
Sep 24, 2020
Messages
706
Tried but getting invalid syntax.
Expression is: [TotalDue]<0.01
 

cheekybuddha

AWF VIP
Local time
Today, 00:06
Joined
Jul 21, 2014
Messages
2,237
OK, that's a weird one! Happens in Acc 2007 too.

Change your expression to:
Expression is: [TotalDue]<CDbl(0.01)
Or:
Expression is: [TotalDue]<Val(0.01)
 

Users who are viewing this thread

Top Bottom