I have found that if I have a layout, a letter for example, with a percentage figure MERGED within the text, I can highlight the WHOLE text, and format number into a percentage. The problem is that any other numbers merged then become percentages.

I have tried inserting a field rather than merging, but as is Filemakers want, it lines up nowhere near the possition I wnt it.

Can anyone help??

Instead of having one block of text containing both number types, break the text up into more than one block.

formatting merge fields this way also works for numbers,text,and time. The drawback is, you can only have one defined format for each type for that text block.

The work-around is as 'rdhaden' posted: break up the text into more that one text block, i.e., have each number merge field contained in separate text blocks.

My suggestion would be to create a calc field that returns a formatted percent as text, then merge that. For example:

numAsPercent(calc,text) = number * 100 & "%"

Is the formatting of merge fields as describled above a feature of FM5 only, I could really make good use of this but can't figure out how to do this in FM4 (The company won't upgrate (yet) to FM5), I only see the option for changing the text properties of the mergefield.

Thanks for any suggestions.

quote:

---

Originally posted by AndriesV:

Is the formatting of merge fields as describled above a feature of FM5 only, I could really make good use of this but can't figure out how to do this in FM4 (The company won't upgrate (yet) to FM5), I only see the option for changing the text properties of the mergefield.

Thanks for any suggestions.

---

Just a brief note:

Upgrades to FileMaker Pro 5 are no longer available. FileMaker Pro 5.5 is the current version. FileMaker, Inc. is offering a special price on FIleMAker Pro 5.5 and FileMaker Server 5.5 until mid-December. Details on their web site.

HTH

Old Advance Man

Thanks for the reply.

Does someone have the answer to my question whether this number formating of text blocks is a feature of FM5(.5) only or whether I'm missing something that is available in FM4.

Thank in advance

You change the number format of the text object as a whole, not just the merge code. In FM4 the number format is not available by right-clicking; you have to choose Format from the menu.

Thanks that solved it