Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to change numeric field size?

Status
Not open for further replies.

needadvice

Programmer
Apr 7, 2002
145
US
I have a numeric field that will only take 9 digits. I changed it to "Double" but i'm not sure what that means. Is this the correct way to expand the field size?
Any Help Appreciated.
 
Check under the Access Help files for FieldSize properties
 
A Double (aka Real) may store values between -1.79769313486231E308 and -4.94065645841247E-324 for negative numbers and between 4.94065645841247E-324 and 1.79769313486231E308 for positive.
For nine digits integral{/b] values, a Long suffice, as it stote values between -2147483648 and 2147483647.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top