put cursor on position in textbox VBA

[ingrid]

Is it possible in VBA to put the cursor on a specified position in aan textbox?

F.E.

I have a textbox with "Ingrid"
I want the cursor to be after the "g"

 

[Mile-O]

Look up the SelStart property.

 

[jgnasser]

Yes Selstart should do that. Relatedly, how would you insert text at the location of the cursor by using code? (not at the end of the existing text)

 

[SforSoftware]

how would you insert text at the location of the cursor by using code? (not at the end of the existing text)

The most simple way is using Sendkeys. (the integrated sendkeys has a bug with turning Numlock off. To be sure, look here:
http://www.mvps.org/access/api/api0046.htm)

 

[WayneRyan]

How about:

Me.txtSample = Mid(Me.txtSample, 1, Me.txtSample.SelStart - 1) & _
               Me.NewText & _
               Mid(Me.txtSample, Me.txtSample.SelStart)

Wayne

 

[SforSoftware]

You're right! I forgot that you can read SelStart to get the current cursorposition

Greetz!

 

[jgnasser]

Strangely, this is not working for me in Access 2000. I get an 'Invalid procedure call or argument'. I tried it out in VB 6 and it works fine and actually it looks very right. Me.txtSample.SelStart always evaluates to 0 when I debug, regardless of whats selected or the position of the cursor.

 

[SforSoftware]

I can't test it in Access 2000, but in Access XP it works fine