Short Text -> Long Text (1 Viewer)

PD1978US1

Registered User.
Local time
Yesterday, 17:16
Joined
Dec 21, 2017
Messages
19
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

..forever waiting... waiting for jellybean!
Local time
Today, 08:16
Joined
May 7, 2009
Messages
19,169
where are you changing it,
in Table Design View?
 

PD1978US1

Registered User.
Local time
Yesterday, 17:16
Joined
Dec 21, 2017
Messages
19
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.
 

Users who are viewing this thread

Top Bottom