 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Percentage
Hi I am new to Access. Thank You for any help. I have this field MilAmt and I changed it to numbers from text within the tblTravel. And also to percentage within format, the dec position is set to 3. When then user types and then press the tab key it replaces with zero's. But before it was working only not with a percentage look. What it looked like before was 0.455 and what I want it to look like is .455%. Please help and thank you! 0.455 is not .455% it is 45.5% If you want the text box to be displayed as a percentage set its properties for format to be percentage. > Hi I am new to Access. > [quoted text clipped - 9 lines] > > Please help and thank you! Thank you for your response... I guess I was not to clear. This field use to be a text field (on the table) also textbox (on the form) and when I try to set the format as a percentage nothing comes up under the pull down. So I turned this field into a number (on the table). Then I was able to enter in the percentage (under format), but now the field will not take changes. Example: user types in 0.455 presses tab key and the field changes to 0.00 What could I be doing wrong... Thank You for any help.. > 0.455 is not .455% it is 45.5% > If you want the text box to be displayed as a percentage set its properties [quoted text clipped - 13 lines] > > > > Please help and thank you! >Thank you for your response... I guess I was not to clear. This field use >to be a text field (on the table) also textbox (on the form) and when I try [quoted text clipped - 5 lines] > >What could I be doing wrong... Sounds like you may have created the field in your table as the default Number datatype, which is Long Integer. Integers are by definition whole numbers, and will not let you enter fractions. Change the field's size property (in the lower left of the screen in table design view) to Double and you'll be able to enter fractions. John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.