I have a Value List in a grid that is bound to a database table column defined as VarChar(4). The datavalue members of the list are all less than or equal to 4 chracters. The Display Text values are all longer than 4 characters.
If the user is keyboard centric they will start typing until the list item of interest is either the current auto complete item or is visible in the filtered set and then use the down arrow to select the item of interest.
The problem that we have run into is that the number of characters that the user can type for auto complete is limited to the database column width (in this case only 4 characters).
How can I get around this limitation for the auto complete functionality? The problem does not occur for the ComboEditor placed on a WIndows Form
Hello ,
What you could do in your scenario is to add unbound column to UltraGrid, which you will populate based on your column which is limited to 4 charts. Assign your value list to this unbound column, handled AfterCellUpdated event of UltraGrid, and if the value of the unbound column current edit cell is valid for your column which is limited to 4 charts, then update the corresponding cell. Also you should hide your column which is limited to 4 charts.
Please let me know if you have any further questions.
Hello Hristo,
Thanks for the quick reply. I am sure that will work, I was hoping there was a more straight forward approach.
You can close this ticket.
NormD