By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Memo linked textbox showing first 255 characters only.

P: 1
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
Jul 18 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418
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)) :)
Sep 3 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.