I have two fields in my database which are calculation fields (First Name -calculated as the first word of a field called First Names, and Sign Off - calculated as a concatenation of ManagersName, paragraph mark and Job Title).

I want to incorporate these into a letter, but using Merge Fields (CTRL-M) I get First Name appearing twice (as in PatriciaPatricia, though it is fine on another layout when displayed as an ordinary field) and the Sign Off only gives the first line,. not the paragraph and second line of display (though again this displays perfectly when displayed as a conventional field).

I have not encountered this before. Is this a bug in version 7, have I got a corrupted file or is there some other explanation please?

Geoff

Merge fields will only expand as far as their defined dimensions, unless they are within a text block, in which case they will expand to fill the box, if necessary. So a merge field containing a carriage return must either be contained within a textbox of the needed size or expanded to contain more than one line.

I am not sure what would cause the double First Name issue. Could you attach a sample, stripped-down file with an example of the problem?

Thanks for the reply. The text box containing the sign-off should be large enough to accommodate the two lines. I can overcome this by merging each of the two fields individually rather than trying to concatenate them into one field and then merging that.

The First Name field still behaves oddly. It shows double when in Browse mode, but usually shows and prints OK in Preview, but not always. I'm only attaching the one file, not the related one containing the sign-off names.

You must make your attachment in *.zip format. Your attachment not readable.