<div>
try something like this<br />
<br />
Private Sub Command1_Click()<br />
Dim str<br />
str = &quot;Thereare two numbers&quot;<br />
Mid(str, 6) = &quot;&nbsp;&quot; &amp;&nbsp;Mid(str, 6)<br />
Debug.Print str<br />
End Sub<br />
<br />
replace str with Textbox name<br />
<br />
<br />

</div>


try something like this

Private Sub Command1_Click()
Dim str
str = "Thereare two numbers"
Mid(str, 6) = " " & Mid(str, 6)
Debug.Print str
End Sub

replace str with Textbox name




<div>
or<br />
<br />
Dim str<br />
str = Replace$(&quot;Thereare two numbers&quot;,&quot;Thereare&quot;,&quot;There<wbr /> are&quot;)<br />
Debug.Print str<br />
<br />
?
</div>


or

Dim str
str = Replace$("Thereare two numbers","Thereare","There are")
Debug.Print str

?

<div>
I am sorry, i might have confused you on the question, i just need to be able to edit the data in the text box, when the data is displayed on the userform i need to be able to click on the textbox to make changes.
</div>


I am sorry, i might have confused you on the question, i just need to be able to edit the data in the text box, when the data is displayed on the userform i need to be able to click on the textbox to make changes.

<div>
How do you display your data? Link/ Bound to a Data Control? Is it a Query from many tables or just from single table?
</div>


How do you display your data? Link/ Bound to a Data Control? Is it a Query from many tables or just from single table?

<div>
So, back to your problem.<br />
<br />
Are you mean you can't change the value (Text) in the TextBox Bound to a DataSource?
</div>


So, back to your problem.

Are you mean you can't change the value (Text) in the TextBox Bound to a DataSource?

<div>
The Locked property was set to to true, thanks
</div>


The Locked property was set to to true, thanks

<div>
<div class="content wysiwyg-content">
Hello, I have a textbox that displays certain data when certain checkboxes are checked, what i need to know is how do i edit the data in the textbox. &nbsp;For example if the textbox reads 'Thereare two numbers&quot; &nbsp;how would i be able to edit the display to add a space between there and are. &nbsp;Thanks
</div>
</div>


Hello, I have a textbox that displays certain data when certain checkboxes are checked, what i need to know is how do i edit the data in the textbox.  For example if the textbox reads 'Thereare two numbers"  how would i be able to edit the display to add a space between there and are.  Thanks

Editing a TextBox

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.