Grids with Memo fields

Michael_Turek

How is this possible when Memo isn't an available column type and the closest type would be text.  If I set the column as text - but I can't edit that grid field like I would imagine.  I expected it to work like a Memo (multiple lines) - but can't get it to work, other than working like a textbox...

 

Can someone enlighten me on this? thx

Jerome_Pearce

No, you cannot edit a Memo field in a grid. You can set one (I think) but you will not be able to edit multiple lines or more than 2000 chars. Also, I think you may have problems if existing data has more than 2000 chars.

Michael_Turek

Thanks Jerome - I would've said thanks earlier  - but every now and then, I have the hardest time signing in to this site.

 

McGaw_Phil

Hi Mike,

 

I've always found issues with editable grids in some shape or form, so I try and avoid them where possible.

I understand why people implement them, because it is an easy approach to a forms on data solution, but I much prefer having "input" controls outside of a grid and then inserting/updating values through the use of a button.

 

The submission might then refresh a read-only grid on the form and show a little green tick status icon to show the submit was successful.

In the latter method you can then have your memo field or a rich text box, and any other controls for that matter, and you'll have better control over the validation of fields also.  Downside is that it will take you 15 minutes longer.

 

Cheers

Phil