Computer Learning Zone CLZ Access Excel Word Windows

Great men do not seek power; it is thrust upon them.

-Klingon Proverb
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Seminars > SharePoint > Lessons
Back to SharePoint Seminar Lessons    Comments List
Max Number of Characters Upload Images   Link   Email  
Carmen Vazquez      
2 years ago
I shared my tables to Sharepoint Lists but now I'm getting an error and I think it's from the table - "The maximum number of characters allowed is 255"

Do I have to clear this setting from all the tables before moving them?
Richard Rost             
2 years ago
What kinds of fields are these? Long text?
Carmen Vazquez      
2 years ago
These are all short text and long text.  I'm getting the issue as soon as I click on the form - even in the date field
Richard Rost             
2 years ago
Interesting. Never seen that behavior before. First run down the Troubleshooter. If that doesn't work, post a few screen shots so I can see what's happening.
Carmen Vazquez      
2 years ago
I will do that and get back to you.
Carmen Vazquez      
2 years ago
I did the following:
1) removed the SharePoint link
2) Compact & Repair (backup too)
3) went through and tested my forms with no issues
4) re-link to SharePoint list
5) delete existing tables
6) re-name sharepoint links since they had a (1) at the end
7) clicked on a field on my form and the pop-up message was:
      The Maximum number of characters allowed is 255

I think I've narrowed it down to a specific table because even though I get the error message it still accepts the date I've chosen, any text entered and drop downs picked until I get to the drop down for this table.  I literally wouldn't let me move out of the field nor save, just kept yelling at me about the maximum number of characters. I had to exit the form to get out of it.  

There is nothing that sets that table apart from the others.  The previous combo box has an OnChange event to requery the Scope Categories combo box.

Carmen Vazquez      
2 years ago

Richard Rost             
2 years ago
That's weird. I've never encountered that before. Try removing options from that list until you find the one causing it? Start with the longest ones? This is one of those things that's very hard to troubleshoot without being able to play with your database.
Jon Capps         
2 years ago
Permissions 10:56 there is a quick blurb about publish entire database to sharepoint, did this get covered in a later topic or class?
Carmen Vazquez      
2 years ago
I managed to fix the issue, I reverted back to local tables.  

There is an option on my Access > Database Tools > under Move Data there's a SharePoint option.

I used that and it got rid of the issue.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in SharePoint Seminar Lessons.


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/21/2024 6:57:05 PM. PLT: 0s