HELP supress duplicate TEXT BOX

[lashwarj]

I have used a text box and placed value fields within it, when I do the supress duplicate it will not supress the duplicates for the text box. How can I accomplish this.

Ex Text box has some text then address info fields

 

[lyanch]

You can create a manual "suppress duplicate". For each field you have placed in the text box..

In the suppression formula for the text box:

Previous{table.field1} = {table.field1} AND
Previous{table.field2} = {table.field2} AND
Previous{table.field3} = {table.field3} etc

Lisa

 

[lashwarj]

lisa,

I keep getting remaining text does not appear to be part of the formula



Previous{Vendor_Info.Address} = {Vendor_Info.Address} AND
Previous{Vendor_Info.City_Town} = {Vendor_Info.City_Town} AND
Previous{Vendor_Info.State} = {Vendor_Info.State} AND
Previous{Vendor_Info.Zip_Code} = {Vendor_Info.Zip_Code}

 

[lyanch]

Doh.. sorry the previous requires paranthesis:

Previous({table.field})

Lisa

 

[lashwarj]

Ths is supressing the entire thing. I shortcuted it and created a formula that does the pasting on the city state and zip, then I am allowed to do the supress duplicate, thank you though