I have two similar tables, one is a local table and the other one is a linked table.
I would like to change all fields with exact name to be the same datatype as the other.
So lets say Table1 has following Fields, Field1 Text, Field2 Memo, Field3 Memo.
I would like some code that should change Table2 Field1 to text (255).
PS. In my case its either memo or text 255, and changes are from memo to text only, not vise versa.
Thanks in advance.