Formatting for printing

[Database Administrator]

Hello All,

Can anyone tell me how one can insert a space between
fields so they print correctly? I am referring to fields that
make up postal addresses.

For example, I have two fields, one for an international postcode
and one for the city.

<> <>

This prints out fine while there is a number in the international
postcode field but when there is no number there the space
that was inserted between the fields remains and the city field
does not appear as fully justified to the left. I have set the layout
to slide to the left when printing, etc.

If I don't insert a space between the two fields they 'run together'
when printed, eg. 85000Serdang.

Is it possible to make a script or something which will create
a space between the two fields when there is data in them both
but remove all space so the city field fully justifies to the left
when there is no data in the international postcode field?

I apologies in advance if this is something quite simple but although
I have used Filemaker for some years (now with Filemaker 6) I
have almost no scripting experience with it.

Best wishes, Tom

[Database Administrator]

In article ,
"Tom Connelly" wrote:

> Hello All,
>
> Can anyone tell me how one can insert a space between
> fields so they print correctly? I am referring to fields that
> make up postal addresses.
>
> For example, I have two fields, one for an international postcode
> and one for the city.
>
> <> <>
>
> This prints out fine while there is a number in the international
> postcode field but when there is no number there the space
> that was inserted between the fields remains and the city field
> does not appear as fully justified to the left. I have set the layout
> to slide to the left when printing, etc.
>
> If I don't insert a space between the two fields they 'run together'
> when printed, eg. 85000Serdang.
>
> Is it possible to make a script or something which will create
> a space between the two fields when there is data in them both
> but remove all space so the city field fully justifies to the left
> when there is no data in the international postcode field?
>
> I apologies in advance if this is something quite simple but although
> I have used Filemaker for some years (now with Filemaker 6) I
> have almost no scripting experience with it.
>
> Best wishes, Tom

One way to do this is to create a calculation field that concatenates
the various text fields with appropriate "If" and "Trim" functions, then
use that calculation field as part of the address label.

In your case the calculation would be as follows:

Trim( international postcode & " " & city)

This concatenates international postcode and city with a space between
them, and trims out the space if there is no international postcode.

--
Bill Collins
For email, change "fake" to "earthlink"

[Database Administrator]

Many thanks for your kind suggestions!

I have made a calculation field and it works well.

Many thanks, Tom

"Tom Connelly" wrote in message
news:Zu2dnbL1a4soqm7VnZ2dnUVZ8jSdnZ2d@bt.com...
> Hello All,
>
> Can anyone tell me how one can insert a space between
> fields so they print correctly? I am referring to fields that
> make up postal addresses.
>
> For example, I have two fields, one for an international postcode
> and one for the city.
>
> <> <>
>
> This prints out fine while there is a number in the international
> postcode field but when there is no number there the space
> that was inserted between the fields remains and the city field
> does not appear as fully justified to the left. I have set the layout
> to slide to the left when printing, etc.
>
> If I don't insert a space between the two fields they 'run together'
> when printed, eg. 85000Serdang.
>
> Is it possible to make a script or something which will create
> a space between the two fields when there is data in them both
> but remove all space so the city field fully justifies to the left
> when there is no data in the international postcode field?
>
> I apologies in advance if this is something quite simple but although
> I have used Filemaker for some years (now with Filemaker 6) I
> have almost no scripting experience with it.
>
> Best wishes, Tom
>