<div>
Try like:<br />
result = mid$(!Co_Name, 1,50) &amp;&nbsp;!Co_Number
</div>


Try like:
result = mid$(!Co_Name, 1,50) & !Co_Number

<div>
= Left$(rs(&quot;Field50&quot;) &amp;&nbsp;space(50), 50) &amp;&nbsp;rs(&quot;Field10&quot;)
</div>


= Left$(rs("Field50") & space(50), 50) & rs("Field10")

<div>
Second one did the job.. &nbsp;many thanks
</div>


<div>
In order to do this accuratly you need to declare to strings of fixed length cast your db fields into the fixed length strings and then concaternate the two strings. &nbsp;Something like this<br />
<br />
Private Sub Form_Load()<br />
Dim str1 As String * 50<br />
Dim str2 As String * 10<br />
<br />
&nbsp; &nbsp;str1 = &quot;David Cassidy &amp;&nbsp;Co&quot;<br />
&nbsp; &nbsp;str2 = &quot;0000001234&quot;<br />
&nbsp; &nbsp;MsgBox str1 &amp;&nbsp;str2<br />
End Sub<br />
<br />

</div>


In order to do this accuratly you need to declare to strings of fixed length cast your db fields into the fixed length strings and then concaternate the two strings.  Something like this

Private Sub Form_Load()
Dim str1 As String * 50
Dim str2 As String * 10

   str1 = "David Cassidy & Co"
   str2 = "0000001234"
   MsgBox str1 & str2
End Sub



<div>
Thanks for the points, I like paul's answer &amp;&nbsp;john's would work as well...
</div>


Thanks for the points, I like paul's answer & john's would work as well...

<div>
<div class="content wysiwyg-content">
Hi, have a field in a table which is 50 characters long and another which is 10 chars long. &nbsp;How would I put this into a string of 60 chars long beginning with the 50 and adding the 10 onto it without it taking out the blank chars in the 50 which are not used? &nbsp;for example..<br />
<br />
&quot;David Cassidy &amp;&nbsp;Co &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0000001234&quot;<br />
<br />
But I get..<br />
<br />
&quot;David Cassidy &amp;&nbsp;Co0000001234&quot;<br />
<br />
<br />
Thanks, Derek.<br />

</div>
</div>


Hi, have a field in a table which is 50 characters long and another which is 10 chars long.  How would I put this into a string of 60 chars long beginning with the 50 and adding the 10 onto it without it taking out the blank chars in the 50 which are not used?  for example..

"David Cassidy & Co                                0000001234"

But I get..

"David Cassidy & Co0000001234"


Thanks, Derek.


Easy Peasy String question(that I have forgotten)

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.