If then statement

[Guest]

Hello,
I need to create code in which the beginning of a field starts with the
words "No
Solution Yet". I can write the code if the entire field equals "No Solution
Yet" (see below), however I can't figure out how to do it if it just begins
with these terms.

If Me.Solution = "No Solution Yet" Then
strMsg = strMsg & "Solution needs to be documented"
MsgBox strMsg, vbExclamation, "Invalid Data"

Any assistance would be greatly appreciated.

 

[Stefan Hoffmann]

hi,

I need to create code in which the beginning of a field starts with the
words "No
Solution Yet". I can write the code if the entire field equals "No Solution
Yet" (see below), however I can't figure out how to do it if it just begins
with these terms.

If Me.Solution = "No Solution Yet" Then
strMsg = strMsg & "Solution needs to be documented"
MsgBox strMsg, vbExclamation, "Invalid Data"

If InStr(Me.Solution, "No Solution Yet") = 1 Then
MsgBox strMsg
End If


mfG
--> stefan <--

 

[Guest]

If 'No Solution Yet' has to be at the start of the field then use:

 

[Douglas J. Steele]

Stefan's solution will also only find it at the beginning of the string,
since he's checking if InStr finds it at position 1.

 

[Stefan Hoffmann]

Stefan's solution will also only find it at the beginning of the string,
since he's checking if InStr finds it at position 1.

Which, of course, is "the beginning of a field"


mfG
--> stefan <--

 

[Guest]

Stefan,

This was just what I needed. Thank you so much!

Leigh

 

[Guest]

Of course - my appologies.

Which, of course, is "the beginning of a field"


mfG
--> stefan <--