My last problem was £ signs turning to Js, this issue was solved by pasting the new £ signs onto a new form and then cutting and pasting them onto the form where they should be.Presumably the main form was corrupted.
My new problem is that access will allow me to display in text boxes data from a join query but will not let me view the data from one of the tables concerned unless it has been joined with the second table. I don't know what is going on here unless it is an error in automatically generated code?