VBA InStr find text and import space

[luckydead]

Hello,
Can someone help me about this:

on my Table1
Type - Short Text



here i put for example text -> SG(C434)
So what i want to do now.

So my textbox (text44) is data control bounded to my table to read information.
If I use textbox.text = someresult will not work I guest.

In reports when i select my select and in textbox to display it like this -> SG (C434) , because i want the text after SG to goes down under the SG.

For find text i readed and used this:
If InStr(UCase(Text44.Text), "SG") Then
'my work here
End if

Any ideas how can I make it,
Thanks in advance.

[ranman256]

=mid(text44,Instr(text44,"(")+1)

[luckydead]

=mid(text44,Instr(text44,"(")+1)

how can i use it like this?
if i type: text44.Text =mid(text44,Instr(text44,"(")+1) I got debugger on this line stop work.

or you mean in control source of textbox itself ?

[Missinglinq]

To be honest I find it hard to follow your scenario...but I suspect part of your problem is here

Text44.Text

You can only refer to the Text Property when the Text44 Control has the Focus! Otherwise you need to use Text44.Value in referring to it.

Since Value is the Default Property of Textboxes...you can simply use

Text44

as

ranman256 did in his code

=mid(text44,Instr(text44,"(")+1)

Also, since Access (unless you explicitly diddle with it) is Case Insensitive, you don't need to use UCase.

Linq ;0)>

[accesstos]

And, after the post of Missinglinq, the only thing a I have to add is this:

Me.Text44 = Replace(Me.Text44,"SG(","SG (")