Dave,

Thanks for the fast response.

The forums threw an error when I posted my edit, so I had to try and edit my post a second time and apparently I omitted the fact that I am using a fixed width font that time around.

Anyhow - in that case character width is the same and therefore not really a hurdle. Also this is an "in house" application so I have total control over the font used and size and don't have to worry about someone else changing them.

This could allow for a "low tech" solution like a background image in the cell but it is not ideal and I would not like to go that route if at all possible.

I have used your solution in one of the predecessors to this application and it was not very well received and dropped altogether in the currently active version.

For the small percentage of time they will actually have to edit the data this may just be something they have to live with or maybe I can do something with the text length and selection start properties on edit of the cell. I'll keep digging, just wondered if anyone else had crossed this bridge or had a better solution.

Thanks Again

Steve

Dave & Mike,

 Thank you both for all your help & guidance. I really do appreciate what you guys do to make this one of the best support forums on the net.

Dave

I really like what you did and can/will incorporate that into other areas of this project, but for this specific issue it's just not as good a fit as what I am doing above.

In all fairness to you - there are other criteria involved (good old feature creep) that I did not include in the initial question because I was hoping it was a simpler solution and didn't want to cloud the issue with any more constraints that I had to. What you provided did in fact cover what I *asked* for just not what I really *needed*

Therefore I have marked both your and my solutions as answers for any possible future readers

Thanks again for your help.

Stephen

Hello,

Thank you for your response.

Please let me know if I can be of further assistance.

Thanks Dave

I'll look at that and see if it's a better fit that all the hoops I'm jumping through above.

Hi Mike,

Thanks for the suggestions.

I am still testing but I think I have a workable solution.

I used some of the information here ( http://stackoverflow.com/questions/17042149/format-ultragridrow-cells ) coupled with the source code of the WinGrid Sample Explorer section referenced in that link to create a custom editor for each cell only if it exceeds the max length

How it works is; during the InitializeRow event I'm calling a Read Only Property from my custom Defaults Class that builds a custom mask for each entry this way I don't have extra trailing spaces in the mask. If the length of data for the field in that row is within the required length the routine returns Nothing otherwise it returns a '&' for every character of allowed length, a Pipe, and a '&' for every character above the allowed length in the length of the string.

        Public Shared ReadOnly Property mask_ExtendedName(point As _IPoint) As String
            Get
                If point.ExtendedName Is Nothing OrElse point.ExtendedName.Trim.Length <= length_ExtendedName Then
                    Return Nothing
                Else
                    ' Start with the Upper Case all Character
                    Dim tmpstr As String = ">"

                    ' Add placeholder for every position in allowed length
                    For x As Integer = 1 To length_ExtendedName
                        tmpstr = tmpstr & "&"
                    Next x

                    ' Add Pipe character
                    tmpstr = tmpstr & "|"

                    ' Add placeholder for every extra character
                    For x As Integer = length_ExtendedName + 1 To point.ExtendedName.Trim.Length
                        tmpstr = tmpstr & "&"
                    Next x

                    Return tmpstr

                End If
            End Get
        End Property

Next I test the results of that routine and if it's NOT nothing then I create a new EditorWithMask using the MaskInput string returned by my routine and set the cell editor to that new editor, otherwise nothing happens and it's business as usual for the grid.

Here's the snipit from the InitializeRow event

            Dim _mask As String = DataLengths.Point.mask_ExtendedName(CType(e.Row.ListObject, _IPoint))
            If _mask IsNot Nothing Then
                Dim editorSettings As New DefaultEditorOwnerSettings
                With editorSettings
                    .MaskDataMode = UltraWinMaskedEdit.MaskMode.Raw
                    .MaskDisplayMode = UltraWinMaskedEdit.MaskMode.IncludeBoth
                    .MaskInput = _mask
                End With
                e.Row.Cells("ExtendedName").Editor = New EditorWithMask(New DefaultEditorOwner(editorSettings))
            End If

I am already using background color change to indicate what cell(s) have errors and my Save routine will trim the data to the max allowed length to prevent SQL based exceptions.

And to answer your first question, it would not be a deal breaker if the Pipe was visible all the time as it would give an indicator of how much free space was left. This current solution works as you describe, showing only the Pipe character when the cell is actually in edit mode, It might actually be nice to have it show all the time once it's set on the values in error because the user then knows how much they have exceeded it limit by without having to click into the cell.

Thanks again for all the help.

Hello Steve,

Here is a sample project demonstrating using the UltraValidator to let the user know when they've entered too many characters.

Please let me know if you have any other questions about this.