Automatic should adjust the height of the edit box automatically when you hit the end of the line assuming you're not using any scripts or DLLs that may affect that. Multiple will set it to a height of 2 (2 lines) at all times instead of only once you get a long line.
If you're not seeing that, try changing the setting to multiple and back to automatic (hitting OK each time).
