Thanks Mike, the Creation filter seems the way to go, I haven't used them before but I'll check out the documentation. 

regards

Darren

Hi Mike, I am kind of stuck..... I can kind of get it working but not on formula columns it seems.... here is the code in case I'm taking the wrong approach....

Public Sub AfterCreateChildElements(ByVal parent As Infragistics.Win.UIElement) Implements

Infragistics.Win.IUIElementCreationFilter.AfterCreateChildElements

Dim column As UltraGridColumn

If (Not (TypeOf (parent) Is CellUIElement)) Then Return

' get the associated column

CType(parent.GetContext(GetType(UltraGridColumn)), UltraGridColumn)

Dim cell As UltraGridCell = CType(parent.GetContext(GetType(UltraGridCell)), UltraGridCell)

' getting the uielement to see if can change text

Dim tTextUIElement As TextUIElement = CType(parent.GetDescendant(GetType(TextUIElement)), TextUIElement)

If column Is Nothing Then Return

If column.Key = "value_9" Then

' tried it both ways, setting the text property of uielement or cell value

tTextUIElement.Text = "999"

' and by setting the cell value

cell.value=999

EndIf

It seems like it changes the value if the field is not a formula? I'm not sure if I should be using drawfilter for this....

EndSub

Hi Darren,

There are a couple of bad assumptions here. The first one is this:

If (Not (TypeOf (parent) Is CellUIElement)) Then Return

You are assuming that the TextUIElement is a direct child of the CellUIElement, but that is not usually the case. You should try to make your CreationFilter account for as many variations as possible.

Here's a better, and simpler way:

    Public Sub AfterCreateChildElements(ByVal parent As Infragistics.Win.UIElement) Implements Infragistics.Win.IUIElementCreationFilter.AfterCreateChildElements

        Dim cell As UltraGridCell = CType(parent.GetContext(GetType(UltraGridCell)), UltraGridCell)
        If cell Is Nothing Then Return

        Dim column As UltraGridColumn = cell.Column

        ' getting the uielement to see if can change text
        Dim tTextUIElement As TextUIElement = CType(parent.GetDescendant(GetType(TextUIElement)), TextUIElement)
        If tTextUIElement Is Nothing Then Return

        If column.Key = "value_9" Then

            ' tried it both ways, setting the text property of uielement or cell value
            tTextUIElement.Text = "999"

        End If
    End Sub

Hi Mike,

There is one last thing i'm having a problem with, I'm using a row edit template and i need to change the text there also, but I can't seem to locate  the item in the tree using getdescendants etc...

i've tried looking for

UltraGridCellProxyUIElement.... which the element view seems to show as the parent?

regards

Darren

You need to look for a TextUIElement - that's the element that displays the text.

BTW... you are applying your CreationFilter to the Proxy control, right? The CreationFilter of the grid won't have any effect on the RowEditTemplate or the controls in it - you have to apply a CreationFilter to the proxy control itself.

Thanks Mike, that was it, for some reason that didn't click in my head to apply it to the proxy field....i'm off to slap myself upside the head.

thanks for all your help.

regards

Darren