Memo Field

[MizLyn74]

I have a database that has two memo fields, when tested the memo field did not limit characters entered but when the database was launched on the company intranet and an employee tried to use it, their entry into these fields was limited....why would that be? I have entered up to four thousand characters on the 'test' version of the database and it still works.

 

[dcb]

Whats your Front End?

 

[MizLyn74]

The front end is Access....but I do have to correct my original post -although the fields allowed input of more characters in the test version of the database - apparently it does cut them off at 255 when you exit the field...I just re-tested.

 

[georgedwilkinson]

And your back end is? And the data type and size for your memo fields on the back end is?

 

[dcb]

and if your backend is a sql server what driver/type of connection are you using

 

[MizLyn74]

Front and back end are both Access 2007. They are both set to memo field and default to 2gb of data.

 

[dcb]

OK
Yip size limit is db size
From what I understand the data is all there but it only displays 255 Char
I have just tested this by pasting a long article into a memo field...
If I enter the field in the table and hit end I dont see the whole thing
If I select all and copy it only copies the first 255
IF I press [Shift] + F2 Its all there.....

See appendchunk and getchunk seems to me (with little experience on this) that access handles this in smaller pieces

mmmm - this should leave you in an interesting dilema....

 

[georgedwilkinson]

When you move data from Access to Excel, it cuts it down to 255 bytes.

 

[boblarson]

This might be something good to read as well.

 

[MizLyn74]

OK
Yip size limit is db size
From what I understand the data is all there but it only displays 255 Char
I have just tested this by pasting a long article into a memo field...
If I enter the field in the table and hit end I dont see the whole thing
If I select all and copy it only copies the first 255
IF I press [Shift] + F2 Its all there.....

See appendchunk and getchunk seems to me (with little experience on this) that access handles this in smaller pieces

mmmm - this should leave you in an interesting dilema....

We went back and tried again, the data isn't there at all - basically the field is behaving like a Text field instead of a Memo field....we have checked everything we know and it just isn't cooperating....I have seen several posts and commentary about Memo fields being truncated in queries or reports, etc but this is actually in the form itself...

 

[boblarson]

We went back and tried again, the data isn't there at all - basically the field is behaving like a Text field instead of a Memo field....we have checked everything we know and it just isn't cooperating....I have seen several posts and commentary about Memo fields being truncated in queries or reports, etc but this is actually in the form itself...

I would suggest posting your frontend and backend so we can take a look.

 

[missinglinq]

Is your form based on a table or query?