Crystal Report?

[blakemckenna]

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


If Length ({tblVendor.venAddr2}) > 0 Then
Trim ({tblVendor.venAddr2})
Trim ({tblVendor.venCity}+", "+{tblVendor.venState}+" "+{tblVendor.venZipCode})
Else
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

[GaryMazzone]

The problem is in the line:
Trim ({tblVendor.venAddr2})
Trim ({tblVendor.venCity}+", "+{tblVendor.venState}+" "+{tblVendor.venZipCode})

It should be:
Trim ({tblVendor.venAddr2}) + " " +
Trim ({tblVendor.venCity}+", "+{tblVendor.venState}+" "+{tblVendor.venZipCode})


You are missing a plus sign (+) after venAddr2 and before venCity

[blakemckenna]

Gary,

If I use that method...both lines end up coming out as 1 line and I want 2 separate address lines.

[RobDog888]

Moved from Classic VB :)

[Tribo]

If you want 2 separate address lines you could try using chr(13)

Regards,
Tribo

[GaryMazzone]

I wrote that the way you had it only. I do the same thing in my reports also but Name the functions Line 3 and line 4. If the second address line is empty the line line 3 becomes the city,state and zip and line 4 is empty. If the second address line is not empty then line 3 is the second address line and line 4 is city state and zip. Both funcitons are placed on the report.