T tubar Registered User. Local time Today, 02:47 Joined Jul 13, 2006 Messages 190 Jan 8, 2007 #1 I Want To Type 4.2 And Access Is Rounding It To 4.0...ive Tried Changing The Format To General Or Fixed But I Cant Get Access Not To Round
I Want To Type 4.2 And Access Is Rounding It To 4.0...ive Tried Changing The Format To General Or Fixed But I Cant Get Access Not To Round
B Bat17 Registered User. Local time Today, 08:47 Joined Sep 24, 2004 Messages 1,687 Jan 8, 2007 #2 in the table design check the 'Field Size'. You will want 'single' HTH Peter
D Darth_Beckett Registered User. Local time Today, 02:47 Joined Dec 29, 2006 Messages 10 Jan 9, 2007 #4 tubar said: I Want To Type 4.2 And Access Is Rounding It To 4.0...ive Tried Changing The Format To General Or Fixed But I Cant Get Access Not To Round Click to expand... As said above change the field size of that value and select either Single or Double depending on your needs. If you are not going to do math with the field you could always just use Text instead of Number
tubar said: I Want To Type 4.2 And Access Is Rounding It To 4.0...ive Tried Changing The Format To General Or Fixed But I Cant Get Access Not To Round Click to expand... As said above change the field size of that value and select either Single or Double depending on your needs. If you are not going to do math with the field you could always just use Text instead of Number
