Recent content by Icepick

I've used FastStone Capture (faststone.org, meh can't link yet :P) which is awesome for screenshots and screen recording in this situation. It's a Shareware, but the licence is pretty worth it if you make lots of documentation which include screenshots. For example it's capable of making a...

I don't, Double, Currency or even Decimal fit my needs. The data stored in these fields are amounts of money so Currency was my first choice and its range is enough to represent the data I want... it's just that with larger numbers the scientific notation kicks in when you are editing a value...

Not really, it does not fix the issue I'm talking about. If you enter "123456789123456.4320" in such field and you save the record, when you click on that value to modify it, Access displays it as scientific notation for you to modify it (then you can enter whatever valid numeric value, but at...

@RainLover: Long Integer is out of the question, I need larger numbers than its limits (otherwise I wouldn't need more than 11 digits in certain cases). Thanks for the details about the different data types and their space usage :) @Galaxiom: I've tried many custom Format values and I've just...

Thanks a lot for your help, after testing the Double type has the same behavior. I also tried to use an Input Mask before posting here but it didn't really fit my needs, the thousands separators would show even when they were not needed while you're typing (that's part of how the Input Mask...

Hello, I have a "Currency" field in a table and it holds large numbers (on which I will need to do basic arithmetic operations at some point, so I must store them as a numbers). I have set the "Standard" format on the TextBox used to display it on a form because I want to have thousand...