Can't get information to refresh/replace in a TextBox

[bralew]

Hi All,

I have the following code:

Please Login or Register  to view this content.

This is one of 8 codes which, when selection is made will populate TextBox5 with a specific code. This happens dynamically as opposed to an older method whereby I pressed a button.
The problem I am experiencing is the information will not replace the previous option, but rather sit along side it. Is there an adaption that can be made to this code so If the user changed their mind, it would override the selection?

[xlnitwit]

How would it know to override rather than doing what you have now? I think you just need to reapply the same logic you used to populate the textbox initially, rather than messing about with the text that may already be in there.

[bralew]

Yes, I see, the code is still putting itself in the right area, right. So, why would it care, what's there already. I thought maybe there was a method that it would replace the contents that's in position 8 rather than sit along side it.

[xlnitwit]

Your code takes the left 8 characters of textbox5, adds the first character from combo7 and then adds the remaining characters from textbox5. It's therefore always adding a new character. If you don't want to do that you should be using 10 and not 9 in the Mid function, assuming you always want to replace the 9th character no matter what.

[bralew]

So do I need to be exploring this sort of thing:

Please Login or Register  to view this content.

the only problem with this is does indeed replace the letter, but deletes anything after it. What Im exploring is the possibility to replace an "X" with an "A" in the middle of a code without influencing the rest of the data.

[xlnitwit]

That code takes the left 8 characters, adds 1, then appends the 10 characters from the 9th character of what was there originally.