jatfill
Registered User.
- Local time
- Today, 13:11
- Joined
- Jun 4, 2001
- Messages
- 150
Hi all,
I've searched on this to no result unfortunately.. but I am wondering if it is possible in Access/VBA to reference highlighted content within a text/memo box. I've tried several methods but nothing seems to work. This is Access 2002/XP.
So for example, if my message above had the word "possible" highlighted by a user, the a button click replaces the selected word with "impossible", retaining the other text around it... make sense?
I looked at the SelText property, which comes close... but if you reference this on a button the selected text gets wiped out when the textbox loses focus to the button. My first attempt at a workaround was to create a shortcut menu, but it doesn't respond to the module command.
I might be asking a bit much of my old friend Access at this point, I don't know... thanks in advance for any ideas!
[edit] OK I was able to get it to see the value of the selected text, but it won't change it to my replacement string, just thought I'd update...
I've searched on this to no result unfortunately.. but I am wondering if it is possible in Access/VBA to reference highlighted content within a text/memo box. I've tried several methods but nothing seems to work. This is Access 2002/XP.
So for example, if my message above had the word "possible" highlighted by a user, the a button click replaces the selected word with "impossible", retaining the other text around it... make sense?
I looked at the SelText property, which comes close... but if you reference this on a button the selected text gets wiped out when the textbox loses focus to the button. My first attempt at a workaround was to create a shortcut menu, but it doesn't respond to the module command.
I might be asking a bit much of my old friend Access at this point, I don't know... thanks in advance for any ideas!
[edit] OK I was able to get it to see the value of the selected text, but it won't change it to my replacement string, just thought I'd update...
Last edited: