|
||||||
|
Percent Bug By Richard Rost 19 months ago Demystifying Percentage Data Entry in Access In this Microsoft Access tutorial I'm going to teach you about a peculiar way that percentages are handled when you enter them into your tables or forms. It may appear to be a bug but it's actually just the way Access works. I'll show you how to work around it, and we'll talk about a better fix for advanced users with a little VBA. Bryce from Lafayette, Louisiana (a Gold Member) asks: I think I may have discovered a bug in Microsoft Access. I have a field to store interest rates and it sent as a double with format percent. If I type in 1.2 then it stores fine as 1.2%. However if I type in .2 then I get 20% which is not what I want. How do I fix this? Links
Recommended Courses
Workaround
VBA Solution
Keywordsaccess 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Percentage data entry, Bug or feature, Data entry workaround, Tips for data entry, Access formatting, VBA programming, percentage data entry, Percent sign format, Decimal point format, Double data type, AfterUpdate event, Fixing data entry errors
|
||||
| |||
Keywords: FastTips Access Fast Tips Percentage data entry, Bug or feature, Data entry workaround, Tips for data entry, Access formatting, VBA programming, percentage data entry, Percent sign format, Decimal point format, Double data type, AfterUpdate event, Fixing PermaLink Percent Bug in Microsoft Access |