>I'm not sure if this is specifically a Web Form question, but here goes...
>
>On my Web Form I use data from an Access table that has a memo field.
>I collect data for that field in a multi-line textbox.
>I save the data into a work row based on the select of the table.
>I then perform my insert.
>When I check the table all I get is 50 characters.
>I know what that is... it's because I don't know the proper specification for a memo field...
>
>
>oledbCMD.Parameters.Add("@Regarding", OleDbType.Char, 50, "Regarding")
>
>
>How should I change the above line to have it work with a memo field?
>
>TIA,
>Rick
I've tried....
oledbCMD.Parameters.Add("@Regarding", OleDbType.LongVarChar, 10, "Regarding")
Is this correct? It seems to work, but should I beusing something else? Also, it doesn't seem to matter what I put in for the size... I currently have it set to 10 and it doesn't seem to care...
TIA,
Rick