Any idea why the Data Type changes automatically from Short Text -> Long Text for a particular field.
Even if I change it back manually and save it over and over it still changes it back.
yes..... when I change it back in the design view and run the query again it works.
Somehow the initial query changes it beforehand, causing the issue.