Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Wed Feb 4 16:02:51 CST 2009
If the client will forgo the decimal point, that would be an even faster solution. 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: 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 Well, if Gustav et al cannot help then as a final solution you could put a hidden field on top of another and have the visible one (Unbound) as a string displaying what you want with the hidden field actually holding the numeric data. Bit convoluted but I like to think laterally (ie, lying down with a beer) <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 18:15 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Decimal point with no places to the right Bound numeric field which needs updating. 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: Wednesday, February 04, 2009 8:49 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Decimal point with no places to the right If it is a "number" that is displayed and not "acted" upon then format it as a string and you can put whatever you want in it. 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 16:28 To: 'Access Developers discussion and problem solving' Subject: [AccessD] Decimal point with no places to the right Dear List: Is it possible to format a number in a bound text box with zero decimal places to the right of the decimal point but still display the decimal point? MTIA Rocky -- 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