Thanks for your help.
I got round it by removing the functions from the calc controls, creating an on format event and then specifying the library the function came from in the code. so:
me.txtDate=vba.date()
or me.txtCustID = vba.format(.....
Works ok now.
I think the missing...