that is, I will either enter nothing or enter a number with the % after it. the percentage will be 2 or 3 digits with the percentage sign following. so i can enter either nothing, or , for ie, an entry of 110% [or 150%, 130% etc] excel handles the % sign, but i do not see access doing it. i use Access 2007 home/student version and i'm on windows vista. thanks!
2007-10-19 13:07:36 · 2 answers · asked by 27ysq 4 in Computers & Internet ➔ Software
I am entering directly into a datasheet, not a form, not yet anyways. can i only do what you're saying in a form view? that is, get to the afterupdate choice?
2007-10-20 15:35:55 · update #1
What is the data type of the field that you are entering it into? If it is a Text "Data Type", if should accept the % sign. If it is a Number "Data Type", it will display the % sign if you make the "Format" of that field in the table Percentage. However, if you type in 150 it will turn it into 15000%. If you type in 1.5 it will be 150%. To avoid this, (if you are entering the data in a form) first go to your table and make sure that the "Field Size" is set to Single. Then put this code on the After Update event of the field where you enter the percentage:
Me.YourFieldName = Me.YourFieldName/100
2007-10-20 13:51:29 · answer #1 · answered by Anonymous · 1⤊ 0⤋
All the position dope trust that yet guy i'm gonna ought to pass with #5!! "Ya Yaaaaaaaaaaaaa" ***EDIT*** Sorry you suggested to p.c.. 2 so i will also pass with 11. yet #5 is the perfect!
2016-10-21 10:40:39 · answer #2 · answered by lisbon 4 · 0⤊ 0⤋