I need a little help with some code

[Jon123]

Me.step = Left(Me.step, InStrRev(Me.step, ",") - 1)

This code works fine as long as it can find the "," but if there is no , entered it errors or. Is there a way I can look for the comma before this code runs?

jon

 

[Mr. B]

Try:

If instr(1, me.step, ",") > 0 then
             Your code here
end if

 

[Jon123]

thank you very much Mr. B

worked like a charm

jon

 

[Mr. B]

Your welcome.