What happens if you change
IF TRIM({RPTINFO.TITLE1}) = "" THEN
to
IF LEN(TRIM({RPTINFO.TITLE1})) = 0 THEN
>I have 2 formula fields in the header of my report, with field
>one positioned above field 2.
>
>If the data field for field 1 is empty, I want to populate
>field 1 with the data from field 2.
>
>The VB syntax function for field 1 is:
>
>
>IF TRIM({RPTINFO.TITLE1}) = "" THEN
> Formula = {RPTINFO.TITLE2}
>ELSE
> Formula = {RPTINFO.TITLE1}
>END IF
>
>
>The problem is, if field 1
is empty in the table, field 2
>does not display.
>
>Any thoughts?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer