How can I change expressions filed size. By default is up to 255 characters. And if the field contains more than 255 characters it can't be outputed to others applications.
255 is a limit for Text Fields (Access, DBase and FoxPro just to name a few also follow this limit). In Order to have a bigger field you will have to use the Memo. This does have limits (you can't sort, calculate etc. Basic stuff) and you are correct Many database have a hard time with Memo fields. Dbase for example stores them separtatly from the other information in that db.