MDB database field limited to 64 or 255 characters

[galapogos]

Hi,

I'm trying to work with an existing database table with some fields already defined. One of them seems to be limited to only 64 characters, so when I try to insert a new item into that field, it gets truncated to 64 characters. I've tried deleting the column in Access and re-inserting a column, but it's limited to 255 characters too. The data I'm trying to store is a text string of 256 characters, so I'm 1 character short. Any ideas on how to increase the character limit? I've read about switching from text to memo field data type, but I can't figure out how to switch. Also, will sql queries work once the change is implemented?

Thanks!

[SoftwareMatters]

You need to change the datatype to a memo field in the table design.
Yes, the sql will still work as long as you don't change the name.