Hi,

I didn't know where else to post this question so I thought I'd try here. I have a formula that is giving me an error that I don't know how to resolve. Here is my code

VB Code:
  1. If Length ({tblVendor.venAddr2}) > 0 Then 

  2.     Trim ({tblVendor.venAddr2})  

  3.     Trim ({tblVendor.venCity}+", "+{tblVendor.venState}+"  "+{tblVendor.venZipCode})

  4. Else

  5.     Trim ({tblVendor.venCity}+", "+{tblVendor.venState}+"  "+{tblVendor.venZipCode})

The error message is:

"The remaining text does not appear to be part of the forumula"

It bombs at the beginning of the 2nd Trim statement in the If branch. I tried using the continuation character "_" and the end of the Then and also using an End If statement and neither of those worked.

Anyone have any ideas?

Thanks,

Blake