hi all. here's my second problem in vb (creating database using ado connection). when i add a new record and get data in text box in the form of number (long integer or integer) this field is not entered and i get runtime error the next time i want to view the data entered: run-time error '94': Invalid use of null what's the reason? u know the format of this textbox is set to number(custom)(in vb) and the field in the database is number(long integer). what type do u recommand for long numbers like "3436565656767" ? i want this data to be shown just in the way i have entered not in the scientific form . but when i set them to long integer they're shown as "444444E+10". what should i do? alenoosh.

Hello alenoosh, Is it necessary to use number type here? I mean u can take it as text type. If u want to use number type then also I am giving u the solution. I hope u might be using MS-Access here. go to table design, number field. set the properties as shown below: Field Size: double Format: Fixed Decimal places: 0 Just set these three values properly and ur task will be completed. Do write back. Bye.

Whenever you assign a field value to a textbox you always use text1.text=""& field value This won't make any difference.