MS Access - Insert Text at cursor with SelText

[ironfelix717]

Hi,

The preferred method of inserting text at a cursor position in a textbox
appears to be setting the Textbox.SelText property.... This doesn't work for me
under any circumstances (RTF or Plain format). It simply erases the entire text box.

See attached.

Thanks for any help.
Regards

 

[theDBguy]

Hi. Just curious, have you tried SelStart instead?

 

[vba_php]

if you can't fix it on ur own, this is dbGuy's solution....

 

[ironfelix717]

Hi all,

The solution provided doesn't meet requirements because it does not insert text at the cursor position.

I've solved this in the attached example. The confusion was in the fact that the value of .SelStart was returning 0 unconditionally. Reason being, the cmdbutton gets focus and re-sets the property value. Storing this in a module var during the On_Click Event of the Textbox is the only solution to retain cursor position.

Thanks for the help!
Regards,

 

[theDBguy]

Hi. Glad to hear you got it sorted out. Good luck with your project.

 

[ironfelix717]

Hi. Glad to hear you got it sorted out. Good luck with your project.

Thanks DbGuy,

Update on this little issue:

This really isn't a good approach still for a multi-line rich textbox. Reason being,
if the user changes the cursor position vertically via arrows or enter or any other means OTHER than the mouse (paste, cut), the position is not captured in the module var. So i added a Textbox_Change event to capture the cursor pos, even still, the solution is lousy and unreliable.

Sad that something so trivial is so difficult. I will not be dedicating any more time to this feature.

Thanks

 

[theDBguy]

Thanks DbGuy,

Update on this little issue:

This really isn't a good approach still for a multi-line rich textbox. Reason being,
if the user changes the cursor position vertically via arrows or enter or any other means OTHER than the mouse (paste, cut), the position is not captured in the module var. So i added a Textbox_Change event to capture the cursor pos, even still, the solution is lousy and unreliable.

Sad that something so trivial is so difficult. I will not be dedicating any more time to this feature.

Thanks

Hi. Unfortunately, everything has limitations. Sometimes, there's just nothing we can do about them. Sorry.