Field size question

Hot Topic

Data vanishing during run time
Calling ActiveX Dll From VB Exe
Exception Handling
Can SOMEBODY HELP?
tables
How to create a web service that enable to comunicate with an exisitng window appliacation
printing multiple paged documents
A problem about get paper size ID.
Show and hide a form
Write data in VB.NET to Access using SQL

Visual Basic

Inheritance Picker Dialog Box Issues
How to start with Barcode scanning?
How to process Large Binary Files
User Control problem
Pause and resume mp3 files in VB 2005
efficient storing and programming for data
datagridview problems
Callbacks, function pointers & structures
Finding text within a seperate application?
DataGrid Update Command in Web Application

Field size question

One of the fields in my Access dB is used for a phone number (XXX) XXX-XXXX

I had initialy sized that field as a long integer but after creating my form in VB.Net found that I couldn't enter all of the digits.

I went back to the dB design and created that field as a Double. Now when I try to run my VB form I get the error saying that the value is either to large or too small for Int32. The expected type is Int32.

I tried changing the value of the Max Length property of the field which was initialy set to 32767.

Then I tried to re save the .XSD file in the solution explorer. still no change.

Does anyone have any idea

Thanks

tattoo

Answer this question

Field size question

  • R. Muti

    Considering that it's a phone number and you're not relying on any calculations with it, I would probably use a string (e.g., varchar(10)). There is no need for double precision for this.

  • David Krmpotic

    Good Point,

    Thanks.
  • Field size question
Answer this question