Memo Field Limited to 255 Characters in Form...

[Lidsavr]

I have a problem, I am trying to figure out and keep hitting a brick wall. I can use some help. I am fairly new to Access and am using version 2007.

I have a table. Several of the fields are MEMO fields as there will be more than 255 characters typed in. I am using a form to populate the table (through a query). I was filling out the 8th record today and the first memo field had 350+ characters in it. As soon as I tab to the next record, the field is limited to 255 characters (the rest of the entry disappears). Here are the field properties I have set up in the table for this particular field:

Table Properties for the field in question:
Field Name: PROBLEM DESCRIPTION
Field Type: Memo
Format: >@
Caption:
Default Value:
Validation Rule:
Validation Text:
Required: No
Allow Zero Length: Yes
Indexed: No
Unicode Compression: No
IME Mode: No Control
IME Sentence Mode: Plural Clause
Smart Tags:
Text Format: Plain Text
Text Align: General

A few of the form properties for the field in question:
FORM:
Name: PROBLEM DESCRIPTION
Control Source: PROBLEM DESCRIPTION
Format: >@
Decimal Places: Auto
Visible: Yes
Text Format: Plain Text
Show Date Picker: For dates
Width 5.5313"
Height: 1"
Top: 3.7708"
Left: 2.0313"
Can Grow: No
Can Shrink: No
Display When: Always
Reading Order: Context:
Scroll Bar Align: System
Numeral Shapes: System
Keyboard Language: System
Enter Key Behavior: New Line in Field

I have not tried any of the other memo fields yet, but all settings are the same.

Any help is appreciated!

Charles (Lidsavr)

 

[boblarson]

It has to do with the query. I think this may help:
http://allenbrowne.com/ser-63.html

 

[chrisper]

Hi, I have the same problem and the above link doesn't help. I am also using Access 2007.

I have several Memo fields in a table. I made a form to update these fields along with fields in other tables. There are no queries or links to the memo fields.

I have removed every bit of formatting and coding that I could find from the fields, but they still cut themselves down to 255 characters on save.

Any ideas?

 

[boblarson]

Hi, I have the same problem and the above link doesn't help. I am also using Access 2007.

I have several Memo fields in a table. I made a form to update these fields along with fields in other tables. There are no queries or links to the memo fields.

I have removed every bit of formatting and coding that I could find from the fields, but they still cut themselves down to 255 characters on save.

Any ideas?

Are you bound to the table or to a query?

 

[chrisper]

As far as I understand it, I'm bound to the table - I actually don't have any queries set up.

 

[boblarson]

As far as I understand it, I'm bound to the table - I actually don't have any queries set up.

Maybe you should try a query instead (just a thought).

 

[chrisper]

Can you point me to a good help resource for setting up a useful query? I'm pretty new with Access and I don't totally understand queries.

 

[boblarson]

A couple of resources:

http://www.accessmvp.com/strive4peace/Access_Basics_Crystal_080113_Chapter_06.pdf

http://www.functionx.com/access2003/Lesson17.htm

 

[chrisper]

Thank you! Much appreciated.

 

[chrisper]

Yup, that fixed the problem. I don't understand why it would truncate my entries when my form was bound to the table. Anyway, it works now that the form is bound to a query.