Usually its a code edit within the messaging app itself. I'd hunt and peck around the web and look for a custom/modded msging app for your specific model of Note 3.
Of course this is all based on if YOUR carrier hasn't put a cap limit on the messaging size that can't be over written even with custom code changes to the app.