Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Change format of column

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-02-24 : 07:45:44
Sorin writes "I want to change the format of 3 columns in my table from "Memo" to "Txt""

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2005-02-24 : 08:33:47
text fields have an upper limit of 255 characters so if you have any data in your memo fields that are longer than that you have a problem and will have to scale them down to within 255 chars or think of an alternative solution. If not then go for it.


====
Paul
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-02-24 : 10:22:57
and PLEASE do not confuse a format with a datatype. VERY different things.

- Jeff
Go to Top of Page
   

- Advertisement -