Should be a really easy if statement

[=?Utf-8?B?Sm9uYXRoYW4gQnJvd24=?=]

I need to evaluate the context of a textbox to see if it already contains a
period. if it does then exit sub, else do this code.

If me.txtbox.text contains a period then
exit sub
else
code...
end if

Is there some sort of function for this? Something like a
contains(me.txtbox.text,".")

I hope this makes sense.

[=?Utf-8?B?Sm9uYXRoYW4gQnJvd24=?=]

Correction. evaluate the CONTENTS of a textbox, not context.

"Jonathan Brown" wrote:

I need to evaluate the context of a textbox to see if it already contains a
period. if it does then exit sub, else do this code.

If me.txtbox.text contains a period then
exit sub
else
code...
end if

Is there some sort of function for this? Something like a
contains(me.txtbox.text,".")

I hope this makes sense.

[kimiraikkonen]

On Mar 8, 10:56*pm, Jonathan Brown
<[e-mail]:

Correction. *evaluate the CONTENTS of a textbox, not context.

"Jonathan Brown" wrote:

I need to evaluate the context of a textbox to see if it already contains a
period. *if it does then exit sub, else do this code.

If me.txtbox.text contains a period then
* *exit sub
else
* *code...
end if

Is there some sort of function for this? *Something like a
contains(me.txtbox.text,".")

I hope this makes sense.- Hide quoted text -

- Show quoted text -

Do you mean:

Public YourSub (....)

If me.txtbox.text.contains("whatsoever") = True Then

Exit Sub

Else

' ...Code

End if

End Sub

[kimiraikkonen]

On Mar 8, 11:07*pm, kimiraikkonen <[e-mail]:

On Mar 8, 10:56*pm, Jonathan Brown

<[e-mail]:

Correction. *evaluate the CONTENTS of a textbox, not context.

"Jonathan Brown" wrote:

I need to evaluate the context of a textbox to see if it already contains a
period. *if it does then exit sub, else do this code.

If me.txtbox.text contains a period then
* *exit sub
else
* *code...
end if

Is there some sort of function for this? *Something like a
contains(me.txtbox.text,".")

I hope this makes sense.- Hide quoted text -

- Show quoted text -

Do you mean:

Sorry, correcting:

Public YourSub (....)

Must be:
Public Sub YourSub(...)

' ...

' The rest is same (below).

If me.txtbox.text.contains("whatsoever") = True Then

* Exit Sub

Else

' ...Code

End if

End Sub- Hide quoted text -

- Show quoted text -

[=?Utf-8?B?Sm9uYXRoYW4gQnJvd24=?=]

perfect!!! thank you. That's exactly what I needed. I knew it was something
simple.

"kimiraikkonen" wrote:

On Mar 8, 11:07 pm, kimiraikkonen <[e-mail]:

On Mar 8, 10:56 pm, Jonathan Brown

<[e-mail]:

Correction. evaluate the CONTENTS of a textbox, not context.

"Jonathan Brown" wrote:
I need to evaluate the context of a textbox to see if it already contains a
period. if it does then exit sub, else do this code.

If me.txtbox.text contains a period then
exit sub
else
code...
end if

Is there some sort of function for this? Something like a
contains(me.txtbox.text,".")

I hope this makes sense.- Hide quoted text -

- Show quoted text -

Do you mean:

Sorry, correcting:

Public YourSub (....)

Must be:
Public Sub YourSub(...)

' ...

' The rest is same (below).

If me.txtbox.text.contains("whatsoever") = True Then

Exit Sub

Else

' ...Code

End if

End Sub- Hide quoted text -

- Show quoted text -

[Cor Ligthert[MVP]]

Jonathan,

AFAIK is mostly this used to see if something exist in a string

if MyString.IndexOf(0,".") = -1 then 'there is no dot.
(you can concatinate that and find as well the second dot.

Cor
"Jonathan Brown" <Jo***********@discussions.microsoft.comschreef in
bericht news:4B**********************************@microsof t.com...

>I need to evaluate the context of a textbox to see if it already contains a
period. if it does then exit sub, else do this code.

If me.txtbox.text contains a period then
exit sub
else
code...
end if

Is there some sort of function for this? Something like a
contains(me.txtbox.text,".")

I hope this makes sense.

[=?Utf-8?B?U3VydHVyWg==?=]

I'm going to suggest INSTR, merely because it is actually BASIC.

--
David Streeter
Synchrotech Software
Sydney Australia
"Jonathan Brown" wrote:

I need to evaluate the context of a textbox to see if it already contains a
period. if it does then exit sub, else do this code.

If me.txtbox.text contains a period then
exit sub
else
code...
end if

Is there some sort of function for this? Something like a
contains(me.txtbox.text,".")

I hope this makes sense.