Darryl Collins
darryl at whittleconsulting.com.au
Wed Sep 11 02:01:52 CDT 2013
One possible solution would be enter the 'number' as a string/text in the form and convert it back to a numeric format upon save/write to the data table. That would work, but also introduces some risks you would have to handle. Cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Wednesday, 11 September 2013 4:48 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Unbound numeric textbox reverts to scientific notation Hi all So no solution or workaround to this? /gustav -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Gustav Brock Sendt: 4. september 2013 09:39 Til: 'Access Developers discussion and problem solving' Emne: [AccessD] Unbound numeric textbox reverts to scientific notation Hi all I noticed this question on Experts-Exchange but found, that I can't figure it out: I have an unbound form. One text box is for currency data (euros) which is great provided the user only uses up to 11 digits. Now, the limit for currency values is 922,337,203,685,477 i.e. fifteen digits, but as soon as a user enters more than 11 digits and moves the focus away from the field and then back, the text box reverts to scientific notation. <snip> I can replicate this but found that it is not related to neither Euro nor Currency; as soon as you apply some numeric format, you'll see this behaviour. Is there any way around it? I've only tested with A2010. /gustav -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com