Hi Eric,

Do you mean that TYPE() is not returning the TYPE or it is returning the wrong TYPE?

Trying prefixing the table field with the Alias.

E.g. cFieldType = TYPE("tablealias.repno")

Gavin...

>Type() doesn't seem to work for a table field.
>
>Is there any other way?
>
>Thanks
>Eric