If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MEMO Field cut off on Form
Hello,
MS ACCESS 2003 on XP Pro. I have a form trying to display a memo field which really only ever stores text (strings if you will). The form cuts the data off at 255 characters despite the fact that the memo has way more than that stored in the table ( and thus the reason for the memo field.) What can I do to get the form to display the entire memo field? Thanks. -- BlueWolverine MSE - Mech. Eng. Go BLUE! |
#2
|
|||
|
|||
MEMO Field cut off on Form
I found the answer!
GROUP BY and SELECT DISTINCT queries will truncate the value of a memo field down to a text field (ie 10000 characters to 255). So the form was based on a group by query and thus was truncated. Once I worked around that I was fine. The only problem will be if I ever NEEDED to have a groupby and display the contents. Although maybe I could perform the group by and then join to the memo field. -- BlueWolverine MSE - Mech. Eng. Go BLUE! "BlueWolverine" wrote: Hello, MS ACCESS 2003 on XP Pro. I have a form trying to display a memo field which really only ever stores text (strings if you will). The form cuts the data off at 255 characters despite the fact that the memo has way more than that stored in the table ( and thus the reason for the memo field.) What can I do to get the form to display the entire memo field? Thanks. -- BlueWolverine MSE - Mech. Eng. Go BLUE! |
#3
|
|||
|
|||
MEMO Field cut off on Form
On Sep 28, 2:40*pm, BlueWolverine
wrote: I found the answer! GROUP BY and SELECT DISTINCT queries will truncate the value of a memo field down to a text field (ie 10000 characters to 255). *So the form was based on a group by query and thus was truncated. *Once I worked around that I was fine. *The only problem will be if I ever NEEDED to have a groupby and display the contents. *Although maybe I could perform the group by and then join to the memo field. * -- BlueWolverine MSE - Mech. Eng. Go BLUE! "BlueWolverine" wrote: Hello, MS ACCESS 2003 on XP Pro. I have a form trying to display a memo field which really only ever stores text (strings if you will). * The form cuts the data off at 255 characters despite the fact that the memo has way more than that stored in the table ( and thus the reason for the memo field.) * What can I do to get the form to display the entire memo field? Thanks. -- BlueWolverine MSE - Mech. Eng. Go BLUE! Hi There, I am facing same problem. How did you display data from query into text box. I mean what is controlsource property for text box ? My query is fetching the correct value but I am not able to display it in textbox. I tried combo and list box but it truncates the data. Thanks, Pravin |
#4
|
|||
|
|||
MEMO Field cut off on Form
On Tue, 27 Oct 2009 18:05:57 -0700 (PDT), Pravin Bhoite
wrote: I am facing same problem. How did you display data from query into text box. I mean what is controlsource property for text box ? My query is fetching the correct value but I am not able to display it in textbox. I tried combo and list box but it truncates the data. Base your Form on the query, put a textbox on the form, and set its Control Source property to the name of the memo field. Textboxes don't truncate (unless you specify a Format property for the textbox); listboxes and combo boxes do truncate. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|