Access maximum character limit - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
Thread Tools Display Modes
Old 12-15-2006, 11:19 AM   #1 (permalink)
True Techie
Join Date: Mar 2005
Posts: 235
Send a message via AIM to Rouen
Default Access maximum character limit

In the fields of an open table for Microsoft Access where you actually input the data seems to have a limit on the characters you can put into it, a maximum of 20 text characters. This is too incredibly small, you can't even fit an address in it, which is funny because it's set to Business in the Wizard Design Table. (What I used to get the database started.) Where is the option where I can increase this size? Thanks a bunch.

Under Tools, I selected Options, then I clicked on the Tables/Queries tab. I see the option Default Field Sizes set to 50, but this doesn't affect the data I can enter per field in the table.

Found out what the problem was, hours later... I was using the Wizard to create a business table, and renamed the fields that were available for selection. The problem was that these pre-created selections also had different pre-defined character limits. I made a table from scratch without using a wizard, the field limit increased to 65535 like it should have been to begin with.
"Just because I'm sitting between you idiots doesn't mean I want to go skiing!"
Network+ Certified
Rouen is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 05:27 PM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2018, vBulletin Solutions, Inc.