Solved

text field type vs. numeric field type

Posted on 1998-08-05
3
205 Views
Last Modified: 2012-06-27
if i have a field that will have strictly numbers in it such as a serial number but i wont be performing any calculations on it, is there any advantage to makeing it a text field type vs. numeric field type?

if possible i would like to get an argument fo both sides of the issue
0
Comment
Question by:Bangerter
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
tuvi earned 10 total points
ID: 1958225
If you want to let Access do the validation, then use a numeric field. That way, Access will check for you.

But if you want to do your own validation, then it is better to use a text field and extract from it. You will have the advantage for range checking, say you limit it to less than 10000, you can check the text length if greater than 4, error. Not only that, user can enter 9999999999999999 and that way out of range for any data type.
0
 
LVL 2

Author Comment

by:Bangerter
ID: 1958226
is that all it comes down to, is validation? ive heard things like dont use a numeric field unless you are going to do calculations, because its faster for a printer to print from a text field then a numeric. but on the other hand a numeric field will take up less space. etc...
any comments in that respect? or is space and speed not that big of an issue anymore?
0
 
LVL 5

Expert Comment

by:tuvi
ID: 1958227
If your database is small to medium size, then "speed and space not that big issue anymore" considering the technology nowadays: anyboday can get a very speedy PC for a cheap price.

What I think it all comes down to, according to a programmer's perspective, is the ease of programming and hencetofore maintenance. You get it to work first with my above comments.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Top 1 of each supplier 55 55
object variable or with block not set 6 28
Calculation in Access 5 25
Switch 5 14
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question