Trim returns a variant (of string type), while Trim$ returns a string.
If you know you're never going to have Nulls, and you're assigning the
results of the function to a string variable (as opposed to a variant),
Trim$ should be marginally faster.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
Quote:
> I was told to use Trim$ instead of Trim on my VB6 code,
> but none gives me a reason. I tested both of them and
> found that they have the same behavior. I looked for Trim$
> in the VB's help, but it sends me to Trim description. It
> looks like if Trim$ is a heritage from BASIC.
> Someone have information about this?
> Thanks,
> Fidias
Trim vs Trim$