Trim({addressname}) + ": " + Trim({Contactname})
and replace both fields with the one formula. You didn't see any chang ebefore
because yuo were t{*filter*} the name object but the contact object was physically
in the place you put it (at the right of name). The locations of the two
objects are not related. What you want is a single object containing the name
and the contact.
Andy House
New Directions C & T Inc.
"We make Crystal sparkle!"
The formula will print out as:
"XYZ Company: contactname"
Quote:
> What I'd need is to have my report using just the essential space to store
> my database's fields' values, keeping the ones who are to be printed on the
> same line as near as possible.
> I.e.: fields <Name> and <Contact>, are both left justified on my report, so
> I'm expected to use the <TrimRight> function.
> I made a "FormulaField" named "Trial" with the same sintax:
> <TrimRight({Address.Name}> ("Address" is my Table Name) and I replaced
> with it the original link to the "Name" field on the report, while "Contact"
> field link remained unchanged (left justified, and always to be printed on
> the same line).
> Then I made a preview but nothing changed.
> Any help is hotly appreciated
> --
> Daniele Berti
> PGP Key ID: ECC14A51
> Key Fingerprint = 4C C0 DB BD 85 D8 E7 D3 C4 63 82 53 DC 7E 82 EC