Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 3
Registered: ‎11-23-2010

text field in datagrid throws error when len>100

Several years ago I edited the Add Opportunity Product grdProducts to include the product.description field which is a text field. All has worked fine until today. Seems as though when you add a product to the grid and the description is larger than 100 characters it throws an exception. I edited the part and made the description 97 characters and it works - 101 it fails. The column was defined as...

    Set col = grdProducts.Columns.Add(0)
    col.FieldName = "DESCRIPTION"
    col.Caption = Application.Translator.Localize("Description")
    col.Width = 130

And I tried...

    Set col = grdProducts.Columns.Add(14)
    col.FieldName = "DESCRIPTION"
    col.Caption = Application.Translator.Localize("Description")
    col.Width = 130
    col.paintstyle = 2

 

Either way fails with the same "Multiple-step operation gerated erros. check each status value." when I try to assign the value of the text field to the recordset...

    .Fields("DESCRIPTION").Value = objRS.Fields("myDESCRIPTION").Value

 

Any suggestion on how I can store the value of the text field in a grid?