Hi group. Hope someone can help me with this. I'm designing a layout which has numerous fields, most of which have defined value lists. I'm trying to get it so I can merge them onto a pre-written form letter. They need to be such that there are commas between words and periods after sentences. My fields are such that the user may need to choose more than one value. I've placed the <<merge>> parentheses in the appropriate location, but cannot pre-place commas because the fields may not always have values.

Any suggestions on using merged fields more efficiently?

Regards,

Confused

This is always a difficult one! The only way around it that I have found is to have calculated fields for the commas. e.g;

Comma 1: If(Field 1 = "", "" , ", ")

Comma 2: If(Field 2 = "", "" , ", ")

etc.

Not very neat but it will work.