sliding in FM 7 not working?

sliding in FM 7 not working?

am 02.12.2007 16:26:07 von kees

I want to print stickers.
On a line I want the zipcode and the city. Sometimes the zipcode is
not avaiblable and I get an ugly gap. FM should slide the fields.
I've aligned the two fields (tops are equal). I've checked sliding for
both fields and I set text alignment to left and top.
The arrows in FM shows the fields should slide. But no sliding in
preview mode or on the print.

I've never could get this sliding to work. Therefor I did create a
calculated field. It inserts a space between the 2 fields if the
first field is not empty and returns the second field if the first is
empty. That worked fine. Unfortunatly it doesn't work any more. FM
prints a questionmark for some records and I can't find a reason for
it (the fields are not empty). Also if I change the formulae of the
calculated field (i.e. always return "xxxx") it is not reflected on
the print anymore.

Any ideas?

Greetings,
Kees

Re: sliding in FM 7 not working?

am 02.12.2007 21:14:17 von Helpful Harry

In article , Kees
wrote:

> I want to print stickers.
> On a line I want the zipcode and the city. Sometimes the zipcode is
> not avaiblable and I get an ugly gap. FM should slide the fields.
> I've aligned the two fields (tops are equal). I've checked sliding for
> both fields and I set text alignment to left and top.
> The arrows in FM shows the fields should slide. But no sliding in
> preview mode or on the print.

Sliding does work (unless there's some peculiar bug in your version
that needs an update downloaded), but it can be tricky to get working
properly.

But for what you're trying to do, Sliding isn't the answer anyway. If
you have two fields on a Layout with a space in between,
eg.
[ZipCode] [City]

then sliding the City back along the line will not remove that space,
so you'll still end up with an address like:

123 ABC Street
Yippee City

with an extra space in front of "Yippee City".

Sliding only closes up empty space in fields, not other spaces on the
Layout.



> I've never could get this sliding to work. Therefor I did create a
> calculated field. It inserts a space between the 2 fields if the
> first field is not empty and returns the second field if the first is
> empty. That worked fine. Unfortunatly it doesn't work any more. FM
> prints a questionmark for some records and I can't find a reason for
> it (the fields are not empty). Also if I change the formulae of the
> calculated field (i.e. always return "xxxx") it is not reflected on
> the print anymore.
>
> Any ideas?

Any Relationships used to retrieve data are still intact?
The Calculation field is set as a Text result?
The Calculation uses the correct fields / Relationships?
The field is wide enough to display the result?
The correct field is on the Layout?

The Calculation field itself would be something like:

ZipAndCity Calculation (Text Result, Unstored)
= If (IsEmpty(ZipCode), "", ZipCode & " ") & City

If all else fails, delete the field and recreate it and see if that
solves it.


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

Re: sliding in FM 7 not working?

am 05.12.2007 16:59:09 von kees

On Mon, 03 Dec 2007 09:14:17 +1300, Helpful Harry
wrote:

>In article , Kees
>wrote:
>
>> I want to print stickers.
>>..........
>
>Sliding does work (unless there's some peculiar bug in your version
>that needs an update downloaded), but it can be tricky to get working
>properly.
>
>But for what you're trying to do, Sliding isn't the answer anyway. If
>you have two fields on a Layout with a space in between,
>eg.
> [ZipCode] [City]
>
>then sliding the City back along the line will not remove that space,
>so you'll still end up with an address like:
>
> 123 ABC Street
> Yippee City
>
>with an extra space in front of "Yippee City".
>
>Sliding only closes up empty space in fields, not other spaces on the
>Layout.
>
........

Thank you for your help. Now I understand what sliding actually does.
I've recreated the calculated field and now it works (don't know
why).

Kees