Tables & Forms Limiting Characters to 255

[KKenui]

I have an Access 2007 database that is not functioning correctly. I have set both the properties in the form and the properties of the table to the "Memo" setting (which should allow 2 GB of data and not limit the characters); however, whenever a users inputs data, it all shows up as if it is being input correctly until they click out of the field, or try to save. Once this happens it is only 'saving' the first 255 characters. i need to get this resolved so we can proceed with finishing the programing. This Memo Field issue is tying us up as we need the end user to be able to input as much information as he requires.

Does anyone have any suggestions or ran into this problem?

 

[georgedwilkinson]

Please describe how you know this is happening. Are you physically counting the characters in the text box? Or are you depending on an external tool to tell you?

If you look at the table's data view, that is not a valid check. If you export data to another Office tool, that is not a valid check (it is a known "feature" of Office products).

I just duplicated your environment (using bound Memo fields) and was able to consistently prove that all of my Memo fields maintain their number of characters past 512, with exceptions. It seems that the text box trim()s the field, removing spaces and crlf characters at the end of the text box.

Please provide more information about how you've proven to yourself that this is happening and how you verified it (using real live counting).

 

[KKenui]

FOUND IT!!! Access 2007 for some reason put an "@" symbol in the format fields. Once I deleted them from both the form and the table it worked!

Thank you for your quick reply!!

I was verifying count by typing in a paragraph or two, then copying the exact paragraph (before clicking out of box so it did not disappear) and then pasting into word to count the characters for me.

 

[georgedwilkinson]

That's a nice trick. I just wrote a little counter on the click event of my text box like this:

msgbox(len(mytext.text))

When I see problems like this the first thing I think of is the tens of hours I spent tracking down and then fixing a "feature" of Office that limits text field in an export to 255 characters.

I'm glad you found the problem.