I have a formula called LegaDescription as follows:
if length ({@LongLegal})>355 then
"See Exhibit ""A"" Attached hereto and made a part hereof" else
{@LongLegal}
------------------------------------------------------------------------------
The LongLegal formula referenced above is:
{Striker.LEGAL} &
IIF(IsNull({Striker.Legal2}), "", {Striker.Legal2}) &
IIF(IsNull({Striker.Legal3}), "", {Striker.Legal3}) &
IIF(IsNull({Striker.Legal4}), "", {Striker.Legal4}) &
IIF(IsNull({Striker.Legal5}), "", {Striker.Legal5}) &
IIF(IsNull({Striker.Legal6}), "", {Striker.Legal6})
------------------------------------------------------------------------------
I have Exhibit “A” set up in a section with the following Suppress (No Drill Down) formula:
Length({Striker.LEGAL}+{Striker.Legal2}+{Striker.Legal3}+{Striker.Legal4}+{Striker.Legal5}+{Striker.Legal6})<=355
------------------------------------------------------------------------------
Both the LegalDescription and the LongLegal formulas are embedded in text fields
When I place each of the legal fields individually on the contract form – the form is populated with the data. However, when I place the formula fields on the contract form – the form is not populated with the data?
I had this working at one time when I only had 1 legal description field.
Any ideas?