Hi,

Field Display (global) : text

I fill this field with :

" " & $count & " " & $value & " " & $name

and it displays

1 12.50 Allen
10 125.50 Arban

I 'd like to replace " " by tabulation so we can have

1 12.50 Allen
10 125.50 Arban

or

1 12.50 Allen
10 125.50 Arban

it there a way to do that or you have another idea ?

Any help would be appreciated

In article <479f8f03$1_3 [at] news.bluewin.ch>, "Jimmy"
<do_not_answer [at] yahoo.com> wrote:

> Hi,
>
> Field Display (global) : text
>
> I fill this field with :
>
> " " & $count & " " & $value & " " & $name
>
> and it displays
>
> 1 12.50 Allen
> 10 125.50 Arban
>
> I 'd like to replace " " by tabulation so we can have
>
> 1 12.50 Allen
> 10 125.50 Arban
>
> or
>
> 1 12.50 Allen
> 10 125.50 Arban
>
> it there a way to do that or you have another idea ?
>
> Any help would be appreciated

Never use spaces to align columns in FileMaker, a word procesor or
anything else (even your examples above are crooked). It won't work
unless you use a fixed-width font like Courier.


The best option would be to put separate fields onto the Layout
(although the "$" in the names might mean you're using Parameters).
That way FileMaker will align the text vertically all by itself. You
can change the text alignment so that the numbers align on the right
instead of left of the field.


If you still want or need to, you can add Tabs to a text field fairly
easily.

First, create a new Global Text field called g_Tab. Put this field
temporarily on any Layout and type a Tab into it in Browse Mode (press
Option Tab on a Mac, I'm not sure what it is for Windows). You can then
delete the field from the Layout.

Now you can use this field in any calculation that needs a Tab. Your
above formula becomes:

g_Tab & $count & g_tab & $value & g_Tab & $name

Put the field onto the Layout where you want it, stretching it wide
enough and tall enough for your needs. Click on the field (in Layout
Mode) and choose Text from the Format menu, then click on the Paragraph
button, and finally the Tabs button. In this window you can set the tab
stops to whereever you want them and can use left / right / decimal
aligned tabs. It'll take a little trial and error to get it right.

Depending on your version of FileMaker, you may be able to set the Tabs
using the Text Ruler (from the View menu), but in my version it doesn't
give the options for the Tabs when you select a field in Layout Mode.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

that's exactly what I search for.

Thank you very much "Helpful Harry", without you
I can never finish my DB !