Im using crystal 9.5 and the database connection is using a microsoft access database and the syntax is crystal.

Field1 and Field2 are both set to type Text in the MSACCESS database.

The below formula is looking to see if either Field1 or Field2 is populated with the "-" symbol.

If it is then display Field3 with a "- " in front of it.
If it doesnt then just display Field3.

It worked fine up until the MSACESS database Field1 and Field2 contained a "+" as its data.

It still displays the "-" symbol, but for data fields containing "+" it doesnt display anything, but it should display the else portion of the statement, which is simply Field3 by itself.

How do I write the below formula so it displays "-" + Field3 when either Field1 OR Field2 contain "-", and display Field3 alone when Field1 or Field2 contains "+"


Formula:
If (Cstr({rpSxData.Field1}) = "-" OR Cstr({rpSxData.Field2}) = "-") then
    "- " + {rpSxData.Field3}
else
    {rpSxData.Field3}

Thanks!