Short Text -> Long Text

[PD1978US1]

Hi,

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.

Rgds,
Daniel

 

[arnelgp]

where are you changing it,
in Table Design View?

 

[PD1978US1]

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.