Selection disrupts MEMO field

[Rainer2000]

Hi there,

In my report there is a MEMO field and I have written a VBA selection:

DoCmd.OpenReport stDocName, acPreview,hereCondition:="Nr=" & [NR]

to select the current record, when I use this selection the contents of the MEMO field is not shown or more specific, contains one or two strange charaters. If i take away the selection, the MEMO field is displayed correctly.

Changing the memo field to a 255 character TEXT field in the table will also correctly display everything, but I would like to have more than 255 characters.

Any Idea ?

Thanks, rainer

 

[phoebe2001]

Try this
Change the Memo Text box on the report so that it is unbound and then populate it through vb code in the detail section, assuming it is in the detail section.

 

[Rainer2000]

Thanks for the hint phoebe.
I do not know how to populate it from the table.

I have tried something weird like:
Private Sub Report_Open(Cancel As Integer)
Me.Text65 = Haupt![Bemerkung]
End Sub

Where Text65 is the unbound field, "Haupt" is my table and [Bemerkung] is the field in the table.
But it did not work.
Thank you for any assistance.

Rainer