ACC: MS Access FieldSize for Text in Table Is Variable Length

 Last reviewed: April 2, 1997
Article ID: Q94221
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

Microsoft Access will set the field length of a Text field to the length of the entered text if the text entered is shorter than the maximum field size.

MORE INFORMATION

When you set the FieldSize property of a table in design mode, you are setting the maximum length for the field. If text entered into that field is shorter than the specified maximum length, then the length of that field equals the length of the text that has been entered. This means whether you design a text column as 20 characters or 255 characters, it will only take up the amount needed to store the actual data entered into that field.

The difference between specifying 20 or 255 characters is that one is limited to 20 characters on entry while the other will allow up to 255 characters.

REFERENCES

For more information about the FieldSize property , search the Help Index for "Fields, size" or ask the Microsoft Access 97 Office Assistant.

Keywords : GnlOthr kbusage
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 2, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.