Anthony,
You are correct!
I just tried it and yes when I click into it, the full text is visible, however when I click away from it again it disappears.
With hundreds of addresses all I need to work out now is how to make all the text visible. I've tried copying and pasting but doesn't help. When I click into the field there are no gaps between the lines so there's nothing to delete.
Thanks for your help Anthony, at least the data is in there, it's just making it visible!
Rachel