data types in access and in visual basic 2005

I am developing with visual basic 2005 and access 2007.
If I set a field to be NUMBER in access, will I be able to enter number "0" into that fields into visual basic 2005 textbox control and then SAVE it to this NUMBER Data type field in access? Or do I need to set some restrictions on the visual basic 2005 textbox within code?
or will the number start at number "1"?

.NET ProgrammingVisual Basic.NET

Last Comment

systems_ax

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Bob Learned

4/15/2008

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

systems_ax

4/15/2008

ASKER

I have just tested and it does save "0", it gives error "data type mismatch" when I try to put in letters, which is great. BUT it does not save decimals. So, if I put 3.4, it only saves 3.
thank you

systems_ax

4/15/2008

ASKER

never mind,
I fixed that.
I have also noticed that if the field is NULL (i do not enter anything), the record will not save until I put in number in, is there a way around it, as I do need to save a record with that particular control being empty.

thank you

systems_ax

4/15/2008

ASKER

Bob,
can you help or should I open another question.
thanks

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

Certified Expert Program

Credly Partnership

Udemy Partnership