Help with TRIM function 
Author Message
 Help with TRIM function

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



Tue, 25 Apr 2000 03:00:00 GMT  
 Help with TRIM function


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



Wed, 26 Apr 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Newbie Help - Trim function in Label

2. Trim function help.

3. Difference between trim and trim$

4. Trim not trimming?

5. Trim() vs Trim$(), etc

6. Equivalent functionality to trim - but with a differenct character set trimmed

7. Trim vs Trim$

8. Trim Function

9. cross trim function and replace command

10. Trim and DateAdd functions No Longer Working

11. Trim() function in query can't be run in Access Runtime Environment

12. Date, Trim, STR Functions Don't Work

 

 
Powered by phpBB® Forum Software