Memo field won't accept more than 255 characters

[ledmark]

Hello! I have a table that contains a comment field where the type is set to Memo. I then built a query based on the table to make a form that populates the table. I'm thinking that the field is a bound field because of this. While I was testing the form and writing instructions I found out that the memo field will not accept anything over 255 character. I have checked the table to make sure it wasn't actually allowing it in the table but not the form - I can type till my fingers fall off but when i tab to a new field or save the form with the save record button it cuts off everything but 255 characters.

Would it be possible to take that field out of the query and make an unbound text box with the control source being the comment field in the table? Is there something I need to set to make it accept the amount of characters it's supposed to?

Thank you for any help!
Laura

 

[John Big Booty]

Perhaps this link will provide you with some food for thought

 

[ledmark]

I found the problem on that information - I had the field formatted to be all Caps - when I took that off it worked fine Thank you so much!!