I agree on this, it would be nice to be able to see the full error text. Double-click to open a text editor with the full text (like in the status bar in the sql or program window) would be usefull, or an ellipsis button as jlcox suggests.
In general, when showing data in grid views, it would be nice to have this option to see the full data, e.g. also in the table editor (e.g. comments in tab page Columns, columns and referencing columns in tab page Keys, condition in tab page Checks etc.)
A work-around is to mark the row in question and copy-paste it into an editor.