problems with the Left() function

[Allen Browne]

References problem. Details:
http://allenbrowne.com/ser-38.html

 

[Mike]

Group

I am using the left function to trim off all but 40 characters. Here is
the line that i'm using FirstLineOfMemo:
Left(tblMemoData!memCommunicationsMemo,40) & "....". The problem i'm having
is that when the form opens on certain machines - usually Windows XP - the
following error apears Function is not availible in expressions in query
expression 'Left(tblMemoData!memCommunicationsMemo,40) & "...."'. I think i
might have to load something. Any ideas?

Regards Mike Sundman

(e-mail address removed)