Ever work with MS ****... er... flex grid??

[mendhak]

I'm working with a flex grid, which I've "connected" to a database, using ADO. When the user clicks on the flexgrid, I bring a borderless textbox there, so the user can type something, and I update the database in the textbox validate event.

That sucks somewhat. I wanted to detect the escape, enter and tab keys, so I moved the db-update code to the textbox keydown event. If the user pressed escape, I'd just remove the textbox. But the keydown event won't detect the TAB and ENTER keys. If it's a standalone textbox, it'll detect it fine. But when it's over the flexgrid, it won't detect enter and tab.

This ever happen to you?
What do you do for the "update"?
Tell me what I'm doing wrong.
Anything else you'd like to add?


TIA.

[Hack]

Why don't you just edit it directly, rather than using a textbox?

[mendhak]

You can't edit a flex grid directly, Hack. Try it.



gee... hope i'm not mistaken....

[Hack]

Sure you can

Private Sub MSFlexGrid1_KeyPress(KeyAscii As Integer)
 
    With MSFlexGrid1
        Select Case KeyAscii
                
            Case 8: 'IF KEY IS BACKSPACE THEN
                If .Text <> "" Then .Text = _
                 Left$(.Text, (Len(.Text) - 1))
            Case 13: 'IF KEY IS ENTER THEN
                Select Case .Col
                    Case Is < (.Cols - 1):
                        SendKeys "{right}"
                    Case (.Cols - 1):
                        If (.Row + 1) = .Rows Then
                            .Rows = .Rows + 1
                        End If
                        SendKeys "{home}" + "{down}"
                End Select
            Case Else
                .Text = .Text + Chr$(KeyAscii)
                'write your own keyascii Validations under 
                       'commented lines
                Select Case .Col
                    Case 0, 1, 2:
                        'if (your condition(s)) then
                            'accept only charectors
                        'Else
                        '   keyascii=0
                        'End If
                    Case Else:
                End Select
        End Select
    End With
 
End Sub

[mendhak]

//stunned

Thanks. I'll try this and get back.

[Si_the_geek]

that's a nice trick hack, but it doesn't work for Esc... what I do is the textbox method, and update when lostfocus occurs - with a boolean which I set if esc is pressed (which then means update is ignored).

Also you could set it to only update if enter is pressed, eg:

Private Sub txtEdit_KeyPress(KeyAscii As Integer)
 
  If KeyAscii = 13 Then
    MSFlexGrid1.Text = txtEdit.Text
    txtEdit.Visible=False
  ElseIf KeyAscii = 27 Then
    txtEdit.Visible=False
  End If
 
End Sub

[mendhak]

Oh dear. I just checked that. Wonderful square boxes there.

And I just edited all my code to fit that. Now you know why i call it the **** GRID!!!


SiGeek: How is the lostfocus method fired? when the user clicks elsewhere on the form? Or a simple tab?

Can you give me a couple more details?

[mendhak]

Originally posted by Si_the_geek
I thought a frog like you would know that!!

it is called whenever the control looses the focus, whether the mouse is clicked elsewhere or tab is pressed.


I reckon your best bet would be the code I posted above, as users will often click out of a text box to cancel it (your choice tho!)

I know it gets fired in when tab is pressed. NOT what I want within the flex grid... i wanted that if the user presses tab, it does NOT lose focus, rather it goes to the next cell... DARN MICROSOFT DARN ****GRID. Aaargh... I feel like wokawidget today.....

AAAAAAAAAAARRRRRRRRRGGGGHhHH....


oh, thanks SIGeek. , ty, hack.

[mendhak]

Hmm... I worked on it. I came back to this post. read it, re-read it and double re-read it.

now I'm back where I started. Isn't that just the sweetest thing?


[FRUSTRATION]
AAAAAAAAAAAAAAAAAAAAAAAAAAARRRRRGGGHHHHH!!!
[/FRUSTRATION]

Is there NO way to capture a TAB inside a Textbox? *sniffle*