>I get this error when i try to mulitply .071 tax with my sold price field. Because some of the soldprices are
>blank and then my varible gets loaded with .F. any ideas what I can do?
>I tried this but it still gives me the mismatch.
>
> if sales(1,1) <> .F.
> thisform.salestax.value = .071 * sales(1,1)
>end if
>
>Thanks Kelly
This is because if your array contains a numeric value, the check for .f. fails with the data type mis-match.
Try this:
IF TYPE("sales[1,1]")="N"
thisform.salestax.value = .071 * sales[1,1]
ENDIF