Change a long text field to text
Thanks to Geoff. As my long-text never was bigger than the textfield size (255) I could use this solution with ease. I did it the following:
Created a new field "textfield"
Did a database action:

INSERT INTO newtable (newfields)
SELECT oldfields FROM oldtable


and then deleted the old field.