I am trying to output a query which in turn will feed a data file (xml) to an exernal app; but the overall field length on some records exceeds 255 characters in some records, and replaces the onerous chracters with a square character. I really must keep each field line intact so that the xml parser will read it, and... to enable me to avoid going cross-eyed at the thought of wading through tons of metatags on multiple lines. what are my options, if any?
well you can set the field in access to memo rather than text is this what you are looking for Regards Kelvan
If the issue is just getting a query to include all the characters, one way to prevent a query from truncating at 255 characters is to SELECT FIRST on that field instead of just SELECT This: SELECT First(MyMemoField) FROM MyTable Instead of this: SELECT MyMemoField FROM MyTable I cannot remember why, but I'm sure one of the MVP's has the reason (and probably a better answer to your question, as well). "efandango" wrote: > I am trying to output a query which in turn will feed a data file (xml) to an > exernal app; but the overall field length on some records exceeds 255 > characters in some records, and replaces the onerous chracters with a square > character. > > I really must keep each field line intact so that the xml parser will read > it, and... to enable me to avoid going cross-eyed at the thought of wading > through tons of metatags on multiple lines. > > what are my options, if any? > >
