Can't locate MaxInputLength.
I have an Access data table with one column being memo format (up 65000 characters).
I have a VB .NET prog which sets up a datadapter/dataconnector/dataset.
The dataset is bound to a datagrid. What shows up in the datagrid "memo" column is truncated to 50 characters.
I did a test of reading the data from the dataset into a richtextbox instead and the same truncation takes place !
-Is this due to a flaw in the wizard's generation of the XML schema for the dataset?
-Is this a limitation imposed bu VB .NET?
or,
-Have I screwed up somewhere and not set some property (or something)?
Hi,
Have you tried looking into the
MaxInputLength property of your column in the DataGrid?
Also, try looking into your DataTable Column for your field. See if the DataType is correct...
Next time post ADO.Net related questions in .NET Framework Data Access and Storage
cheers,
Paul June A. Domag
I can't find the datagrid property of MaxInputLength.
Even did a search on MSDN.
Can you tell me how to access it, as in "datagrid1.xxxx.....MaxInputLength" ?
The data type is ok.
I am in the process of rewriting the prog to work without a datagrid, but I would still like to know what is going on.
Thanks for the response.
Hi,
Well its in the designer...
Select DataGrid, right click and select edit columns.
Select the text column you want to edit, find the MaxInputLength in the properties (Under Behavior Group)...
I wonder why it doesnt show up in MSDN Search... 
cheers,
Paul June A. Domag
Wow ! Do I feel dumb. I select the datagrid and right click.
All I see are the choices below..........I see no "edit column."
We are talking VB .NET , right ?
Sorry to be such a bother, but can you help one more time ?
http://www.pbase.com/nupbase/image/43105279.jpg
Hi,
So sorry, my mistake...
I was assuming that you were using VB.Net Express 2005. Coz almost all the posts here are about 2005...
Ok, I'll try to look into it in VS2003...
cheers,
Paul June A. Domag
I am using ASP.Net 1.1, VB.Net and MS Access 2000 and populating fields on a DataGrid control. I had a similar problem with data in a memo type field being truncated to 255 characters using the following SQL statement:
SELECT fpID, pID, Part_Seq,
uCase(Part_Number) as Part_Number,
UCase(Description) as [Description],
format(Date,'Short Date') as [Date],
ucase(Requestor) as Requestor,
uCase(manufacturer) as manufacturer,
ucase(Manu_Part_Number) as Manu_Part_Number,
ucase(Note) as [Note]
FROM FAMILY_PRODUCT I realized that the uCase function was changing the field type of my Note field from a Memo to a String type. I was able to fix this problem by removing the uCase statement for Note from the SQL statement which solved my problem:
SELECT fpID, pID, Part_Seq,
uCase(Part_Number) as Part_Number,
UCase(Description) as [Description],
format(Date,'Short Date') as [Date],
ucase(Requestor) as Requestor,
uCase(manufacturer) as manufacturer,
ucase(Manu_Part_Number) as Manu_Part_Number,
Note
FROM FAMILY_PRODUCT
Are you performing any functions on your Memo field that may be changing it's data type?
Hope this helps.
