I've linked a spreadsheet to my access database, but my "notes" field in my TBL gets cut off after 255 characters. I can see the whole note in the original linked table, but it won't translate to my access table. I've tried changing it to long text, but nothing happens. I've got things set up to "Review" differences and it's hard to discern real changes because it pulls up the cut off note and the original entire note/message. Anyone know how to fix it?
Kevin Yip
@Reply 3 years ago
Increase the row height in the table to allow multi-line display. If the row height is only single line, it may look like the long text is cut off.
Scott Axton
@Reply 3 years ago
Check out the Zoom video. Specifically the extended cut. That show how to control what size the box is when you click on it in a form.
Melissa DonnellyOP
@Reply 3 years ago
Hi, neither of those solutions worked. What I ended up having to do was an update query into a new field that changed the original criteria of the linked table from Short Text to Long Text (rich). I'm not working with forms. Either way, the issue was resolved, just took a few extra steps.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
