Field Size

  • Thread starter Thread starter Hal
  • Start date Start date
H

Hal

Using Access 2000, I want to create a table containing a list of products
(product code #, product name, description, price, etc..) and Export it into
a Pipe Delimited file.

Some of the Product Code #'s are 12 & 15 digits long. I have selected
"Numbers" under Data Type.

My questions is: what should I select under "Field Size" (Byte, Integer,
Long Integer, Single, Double, Replication ID, or Decimal)?

Thank you in advance.

Hal.
 
Hal,

Assuming product code # is integer (no decimals), you should use Long
Integer.

To understand the different data types, open access help, use the Answer
wizzard to searc for Long Data Type, click on the See Also link on the
righthand side and select Data Type Summary.

HTH,
Nikos
 
Nikos

Long numbers have a Max of 2 ^ 31 - 1, i.e. only max 10
(decimal) digits.

Hence, I don't think Long will satisfy the O.P.'s
requirements.

HTH
Van T. Dinh
MVP (Access)
 
Since you are not doing any calculations with the
ProductCode, the solution is a Text Field (of length 15+)

HTH
Van T. Dinh
MVP (Access)
 
Van,

You are absolutely right on the number of digits, I overlooked that.

You are also correct on the no calcs => text comment; yet, I have been using
integer fields for product codes (shorter, of course), so (a) they will not
accept non-numeric characters entered accidentally (when I started this
practice I wasn't into VBA so as to consider validation in code), (b)
sorting is correct regardless of length, (c) ranges can be used in filters /
criteria, and (d) it saves storage space in big tables.

Thanks for pointing out my oversight,
Nikos
 
Thank you for your great help. I have tried Text Field. However, I am
getting little Squares in certain locations. Can anyone shed some light?

Thanks.

Hal.
 
Back
Top