>>Hi everybody,
>>
>>I have a SQL table where several columns defined as varchar(max). I want to be able to display this table in a grid and be able to edit it directly - inline.
>>
>>I am thinking of how to approach this form. Should I display the first 200 chars in every column and when I click on a column, somehow have it expanded into an editbox?
>>
>>Appreciate the ideas and also the idea of how to handle adding new records with this interface that will be convenient for the user.
>>
>>Thanks in advance.
>
>Hi,
>
>Although I read you have already found a solution, you could consider to drop a container in your grid,
>the containeer containing an editbox and a button with a magnify icon. The editbox should be only 1 row height like an trextbox, the button activates a nwe form with an editbox - reasonable size an apply and revert button. I believe this UI will be familiar to most users. In fact VFP users know it from the Property boxes in the ProjectManager
>
>Regards
>
>Koen
That's actually what I implemented - a container with a editbox looking like a textbox and a small button with 3 dots in it - this button simply calls Modify Memo functionality. So, the container class is very simple, but it took me a while to realize to use an editbox instead of the textbox - and that's what Gregory suggested right at the beginning, but I had to fiddle with the textbox for a while before abandoning my stupid attempts and realizing a simple solution right under my nose.
If it's not broken, fix it until it is.
My Blog