255 max text fields?

[tomas_s]

What is the difference between "short text" and "long text"?

Both seem to have 255 characters limit.

Also, and ideas to work around it?
Is there no way??

ps. I have Access 2013, and I found a solution, that you can use Memo instead of Short text. But the problem is, that there is no "memo" data type in Access 2013. So that won't work for me.

 

[Mihail]

What is the difference between "short text" and "long text"?

Where are this properties ? I have knowledge only about "short date" and "long date".

 

[tomas_s]

When I'm in a table, and in design view, I can pick number, short text, long text etc.

 

[Mihail]

Still I don't think so. Check again.

 

[tomas_s]

I got 2013 version of Access. Trust me, it is there.

 

[tomas_s]

I can tell you all datatype options:

short text
long text
number
date/time
currency
autonumber
yes/no
OLE object
hyperlink
attachment
calculated
lookup wizard

 

[Mihail]

Ok. Sorry for this. I have only 2007.

 

[GS500]

I found the following info Here:

The Text data type has been renamed "Short Text." A Short Text field can contain up to 255 characters in a desktop database. In an Access app, the default character limit is 255, but it can be increased to 4000 in the field properties.

The Memo data type has been renamed "Long Text." A Long Text field can contain up to about a gigabyte of data in a desktop database, and up to 2^30-1 bytes in an Access app.

 

[The_Doc_Man]

The biggest difference between the two is a practical one. You can index a text field - short text, in your distinction - but not a memo field. There are some limits on searching a memo field, too. You also pay a speed penalty because of buffering issues. Normally a single Access record has to fit into a buffer of (I think) 2048 bytes. Obviously, a Memo field could exceed this range easily, which makes processing harder.