access link text field as memo

message from Andy Levy on 4 Jun 2004
Hi

I have a strange problem. I have two tables in a MySQL database. Both
tables have text type fields - however for one table access shows that the
field is of the 'text' type and the other table it shows it is of the 'memo'
type.

Has anyone got a clue as to how this can happen?

Thanks

Andy
 
John Vinson replied to Andy Levy on 04 Jun 2004
I believe that if the size of the field is over 255 bytes Access will
define it as a Memo.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
 

Archived message: access link text field as memo (Microsoft Access)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.