Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Thu Feb 5 09:14:27 CST 2009
I find it is often better to let the user see what they think will work well then after they see it, do it again with what they know will work well. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Thursday, February 05, 2009 3:32 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Decimal point with no places to the right Might be worth asking WHY and then you may get the chance to suggest alternatives. That is the difference between Analysts and Programmers <g> Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: 04 February 2009 23:07 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Decimal point with no places to the right I don't know. Client requests it. I do it. :) Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, February 04, 2009 3:03 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Decimal point with no places to the right But Rocky, why would you show a decimal point at all if you aren't going to show the decimal places? That doesn't make any kind of sense to me. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Wednesday, February 04, 2009 2:07 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Decimal point with no places to the right The field is a double but the user doesn't want the decimal places to display. The format example has the value and the mask as the two arguments for the format. But in this case the value is in a bound text box on a continuous form. So I can't use the Format on the control source. So not sure how to get the text box to show the whole number plus the decimal point without the decimals fractions. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Wednesday, February 04, 2009 11:01 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Decimal point with no places to the right ? format(111&,"0.#") 111. Too true. Works for integer types, though not sure if Rocky specified integers. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Wednesday, February 04, 2009 1:46 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Decimal point with no places to the right Hi Lambert > Your format string shows one decimal place (as I would expect it to) Yes, but none for an Integer - that I understood was the issue. /gustav >>> Lambert.Heenan at aig.com 04-02-2009 19:23 >>> Gustav? Your format string shows one decimal place (as I would expect it to) ? format(111.12,"0.#") 111.1 This shows no decimal places... ? format(111.12,"0.") 111. Lambert -- 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 -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com