ComboBox limiting field data!

[rkdcomp]

I have a ComboBox that uses a table with 2 fields, an ID Field (AutoNumber) and a Memo field.

The Memo field can contain some long text which is needed to fill in a field in a record.

Everything was working fine unti I added a record to the Memo field that was quite lenghtly, about 180 characters.

Well on the form that has the ComboBox, when I select this long character record, it only shows 153 characters and 153 characters are inserted in the field in the underlaying record set.

I have played with this and can't find out why it's truncating the data.

Going to the table to which the ComboBox is bound, all the data is in the field.

Pulling my hair out.

Thanks!
Richard

 

[thornmastr]

Here are two answers. Pick one and good luck.

1)"The problem your hitting is that a combo box will only keep 255 characters
of a memo field (as you have found out ). One solution would be to use
DLookUp - something like the following

Me![TermDescription] = DLookup("[Memo Field Name]", "MEmo Field Table",
"[Unique ID for Record] = " & Me![TermID].Column(0))

This assumes that the first column in the combo box conatins the Record Id"......Terry Wickenden


and

2)"Try using the 'GetChunk' and 'AppendChunk' methods to transfer the contents of the memo field. "...Jim Pettit


Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[rkdcomp]

Robert:

Thanks for the speedy reply. I was trying everything I could think of to get the FUUL text of the field to appear in the ComboBox with on luck.

You gave me an idea on the DLookUp.

I can still use the truncated data in the form and it's just rea;;y there for a reference. The important thing is to have the data appear in the body of the letter where it's needed.

I can is the ID field as the link and when the report is formated for print, I can have it use the DLookUp to insert the "full" data in the letter.

I haven't got time to play with it right now, but will let you know how I work around the 255 limit.

Regards,

Richard