By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,599 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 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
Daniel
Jul 18 '06 #1
Share this Question
Share on Google+
1 Reply


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

Post your reply

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