"Length" in table design view

From: cmaso (cmaso_at_discussions.microsoft.com)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 11:41:03 -0800

I haven't been able to find an answer to this simple question from any of the
online documentation. In table design view, each one of my columns has a
datatype and length. Specifically, I have a column of dataype "ntext" with a
length of 16, but I don't know what that "16" means. 16 Bytes? How can I
determine the appropriate length to set it to, based on how many characters I
expect the field to hold?

Is there anywhere that explains in simple terms what each datatype is and
what the "length" means for each individual dataype? Thanks!

Relevant Pages

  • Re: convert per cent text to number
    ... Same result with your suggestion. ... Please open the Table in design view and select this field. ... datatype in the second column of the field description? ...
    (microsoft.public.access.queries)
  • Re: switch function
    ... Open the *table* in design view. ... What is the data type for the field CHN_CD? ... Is it a Number datatype or Text? ... Do you get an incorrect value? ...
    (microsoft.public.access.forms)
  • Re: Numbers and Decimals
    ... Put the table into Design View, set the column's DataType ... to Numeric and set its FieldSize to Double. ... Gerald Stanley MCSD ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Decimal Points
    ... >I have tried every option in table design view to show 1-2 decimal point ... The default Number datatype is "Long Integer" - and an integer is, ... with NO roundoff error, use a Currency datatype. ... explicitly set the number of digits and of decimal places, ...
    (microsoft.public.access.gettingstarted)
  • Re: Can only enter 4 characters in Client Table
    ... Open the Table in design view. ... sure that the datatype is Text; and the size (in the properties at the ... four characters. ... John W. Vinson ...
    (microsoft.public.access.gettingstarted)