Populate memo field from lookup

R

Rick

I have a table ParagraphText which is populated with standard text paragraphs
to be used in invoicing. The fields are as follows:

1. DetailedText memo
2. DetailedID autonumber PK

The field ParagraphDetailText in the Invoice table is populated via lookup
on the ParagraphText table. The corresponding field on a form is bound to
column 1 which is the memo field DetailedText. Limited to list is set to No.

The lookup performs as expected with the exception that Access parses the to
256 characters when polulating the ParagraphDetailText with the DetailedText
data.

Several of the memo fields in the lookup table are over 256 characters in
length.

Is there any way to populate the ParagraphDetailText field with the entire
text string in the DetailedText field in the lookup table?

TIA
 
Top