Field Changes Format in Report Mode

[Joseph31]

Wow you guys I hope this is an easy one

Here is the set up:

I have fields that I can enter information in these fields are formated for Numbers ($ & 1,000 seperators)...This is great...But when I bring these same field in the form of <<amount>> to my report they change into percentages (%). Why and How can I stop this...I can not make just fields on my report b/c there are in a paragraph. This is a huge problem for me.

I have come up with makeing these field just text fields and that works fine. But what a pain to enter information and also have to formate it yourself....Very slow..

Thank you

FileMaker Version: 6

Platform: Windows 2000

[-Queue-]

You should be able to right-click on the paragraph and select Number Format.

[Joseph31]

even if it is like <<amount>>...I could not figure out how to do that...Its not a cell...I know how to do that for a cell

[-Queue-]

Yes. Just right-click on it and you'll see the formatting options.

[Joseph31]

that only works for cells in a report I have text cells...I have tried to click on them I don't see it...

[-Queue-]

There are no cells in FileMaker. There are fields, and whether they are normal fields or merge fields, you can select and format them in Layout Mode. If they are merge fields that are part of a larger text group or solo, you can format them by either right-clicking on them/the group or selecting them and using the Format menu. What DO you see when you right-click on the merge field or its text group?

[Joseph31]

I see Font...Size...Style...and text color...

[-Queue-]

Not Browse Mode, Layout Mode. Press Ctrl-L, use the View menu, or select from the pop-up menu on the bottom left, next to the Status Area.

[Damocles]

In Layout Mode, when you go to format the number, do not select the text in the text field. Click on the ENTIRE field, so that the field has little squares at all four corners of the field.

With the entire field selected, click on the Format menu. Select the Number option. From there you can format any numbers in the text field with the appropriate currency symbols.

Paul

[Joseph31]

Sorry abou the delay I had to go out of town...I did what you said and the options are like I want but for some reason the numbers show up as % not $...and I have checked the option...they say $ for that field

[Damocles]

A picture is worth a thousand words, and my typing is marginal at best. Here is 2,000 words to help....

Paul

Number Format.zip