Maximum number of characters?

[Stiltskin]

This is probably a really simple problem, just that I'm not too good with access.

I'm trying to update a SQL database through Access, using a form. However on one record it is clipping (deleting) the end off what I type in the text box.

The table is set as varchar 7500 and what is written in the text box is well under that, 3918 including spaces. Why is not allowing me update it more than this number of characters?

 

[jeremie_ingram]

Try changing the associated field properties to MEMO instead of text.