Only half of if statement working

[fixemup27]

What am I missing peeps. I can only get half of my "if" statement to work, and it's the "false" half..its as follows: =iif([Proceeds]>[Value],"acceptable offer","unacceptable offer)...Only the second half works...this is stated in the "control source" (properties) in an unbound box that is named "result" and refers to two other bound fields. Please help..Thank you.

 

[pbaldy]

Are they perhaps text fields that won't evaluate properly mathematically?

 

[Mist]

offer)... - offer")... ? or just a typo error here only? Relatively new to VBA myself

 

[pbaldy]

You are correct that there should be quotes at the end. I assumed that was a typo or it would generate an error rather than give the false result.