jwcolby
jwcolby at colbyconsulting.com
Thu Feb 5 08:52:40 CST 2009
Amen! John W. Colby www.ColbyConsulting.com William Hindman wrote: > ...Lesson #1 in how to survive as an independent Access developer. :) > > William > > -------------------------------------------------- > From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com> > Sent: Wednesday, February 04, 2009 6:06 PM > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > 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 >> >