Use merge fields instead of concatentating all the fields in a single calculation.
For each address field that needs to end in a comma,
Define the following auto-enter calculation:
If ( Right ( Trim ( Self ) ; 1 ) = "," ; Left ( Trim ( self ) ; Length ( Trim ( self ) ) - 1 ); Trim ( self ) )
Clear the "Do not replace existing value, if any" check box so that this expression will update the field after any edits done to it.
This expression will remove any commas from the end of the field. (For existing records, you'll have to update them to strip out the commas). I'm recommending you remove the commas from the fields so that they can be consistently added as layout text instead.
In layout mode, use Use the Layout text tool to start a block of layout text and select Insert | merge field... to add each field to your layout. Add the commas and carriage returns as part of the block of layout text. When done, it'll look something like this while in layout mode:
Thanks for your help, thats great!
I'm just starting out with Bento - all the address book headings are in US style but they appeared to be locked. How do I go about changing them? I want to be used to insert more address lines.
Thank you for your post.
If you click on the pop-up for type of Address ("work", "home", "other", etc.), select the last option "Change Address Format", and select the style you want.
In the future, since this is a FileMaker Pro forum, please post your questions to the Bento forum at http://forums.filemaker.com