Conditional Formating in field 1 fills text in field 2

[CraigR]

I have a field that is a calculation of 2 other fields. The calculation provides positive or negative numbers.


The field is calculating depth of cut or fill for earthworks.
So the calculation goes like

[Field 1] - [Field 2] = [Field 3] [Field 4]

if [Field 3] calculates a negative number I want [Field 4] to display the text "FILL"
If [Field 3] calculates a positive number I want [Field 4] to display the text "CUT"

thank you in advance for any help
Craig

[pbaldy]

Try

=IIf([Field 3] > 0, "Cut", "Fill")

[CraigR]

Thanks, but I receive an error message
"The expression you entered contains invalid syntax"
"You may have entered a comma without a preceding value or identifier"

???

[andy49]

Pbaldy’s syntax seems fine. Did you place the line in your field 4 and rename field3 part.

[CraigR]

I keep getting the same error

I have called my calculation field actually "Field 3"
and called conditional formatted field "Field 4"
I have clicked on "Field 4" and clicked "Conditional Formatting"
Conditional Formatting Rules Manager.... opens
Show formatting rules for Field 4
Click "New Rule"
Check values in the current record or use an expression
the drop-down I select "Expression is"
and in the line I paste =IIf([Field 3]>0,"Cut","Fill")
when I click OK above error message appears

[andy49]

Conditional formatting not needed. On the form you’re using, click in field4 in design mode and enter the line you were given. Field4 will automatically work based on field3

[CraigR]

Thank you both

Craig

[pbaldy]

Conditional Formatting would affect the format; you wanted to affect the content.