[AccessD] MEMO fields in UNIONS

Hi Jim

> This will return the first 255 characters of the field correct?

That's right, but quite often that's enough.
If not, I have used the method with outer joins to the base tables,
but I guess this suggestion of yours could be used as well.

/gustav


> Off the top of my head, couldn't you write a function that returns a string containing the entire contents of the Memo field?  A
> string variable can hold more than 255 characters as in:

> <snip>
> Dim s As String
> Dim i As Integer
>     s = String(500, "x")
>     MsgBox Len(s)
>     For i = 1 To Len(s)
>         Debug.Print i & Mid$(s, i, 1) 'just to prove they're all there!
>     Next i
> </snip>

> So why not write a function that returns the memo field in a string
> Function ConvertMemo2String(MyMemo as String)
>   ConvertMemo2String = MyMemo
> End Function

> Usage:
>         Select ConvertMemo2String([MyMemoField])...

> It's a WAG but worth a try.

> HTH,

> Jim DeMarco
> Director of Product Development
> HealthSource/Hudson Health Plan


> -----Original Message-----
> From: Gustav Brock [mailto:gustav at cactus.dk]
> Sent: Wednesday, February 12, 2003 1:52 PM
> To: Mark A Matte
> Subject: Re: [AccessD] MEMO fields in UNIONS


> Hi Mark

> Yes:

>     Select Left([fldMemo],255) ...

> /gustav

>> Anyone have a workaround or method of displaying MEMO fields in a UNION
>> query?