Memo linked textbox showing first 255 characters only.

[DanielPayne]

Hi I am created a database to link to a website and have completed the form for creating a new product where a description field (memo) can be typed. When I create a product, the full description is saved to the table. However, I have created another form where you can create a product like a previous one by selecting it from a list. When it is selected it populates all the other fields properly apart from the description field where it shows only the first 255 characters. I read this could be because the query used to get this data uses either the group by or distinct functions, but it doesn't. What am i doing wrong, is their an alternative way? Thankyou
Daniel

[PEB]

Hi,
In fact 255 is the largest string /text property that can exist in Access! Obviously in your query the Memo field is considered like a text and not like a real Memo!

to escape from this instaed to try an update of information from the combo list you have to try to get the needed information directly from the table with the memo!

Using the function:
Dlookup("MY_MEMO","My_table","My_table_ID="+str(Me !ID)) :)