Hi All,
I not understanding why this is not working

If Len(InStr(1, MyRec!CmpltdUnits, ".")) = 0 Then

cmpltdunits is a double datatype(fieldsize) and if the value in
myrec!cmpltdunits is 1 the above does not valuate to true.

cmpltdunits could contain as an example .34 or 1 or 53.24, etc...

what I'm trying to do is detect if the value has a decimal point in
it. If the above is not correct then what is the correct expression.
thanks
bobh.

ok, this worked

If Len(Right(MyRec!CmpltdUnits, InStr(MyRec!CmpltdUnits, "."))) = 0
Then

bobh.

On Jan 23, 11:00*am, bobh <vulca... (AT) yahoo (DOT) com> wrote: