Darren DICK
darrend at nimble.com.au
Mon Jun 26 09:43:07 CDT 2006
Hi Gustav That's exactly what Michael Madisson sent yesterday - many many thanks for the response Many thanks Darren ------------------ T: 0424 696 433 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Monday, 26 June 2006 4:45 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] A2003: Showing to 4 decimal places Hi Darren You could use a format string like this: ? Format(yourvalue, "0.0###") /gustav >>> darrend at nimble.com.au 26-06-2006 02:06 >>> Hi All <sigh> brain fade here - what is the correct syntax to show a display up to 4 decimal places But some numbers will genuinely be 1, 2 or 3 decimal places and as such only need to show 1, 2 or 3 decimal places respectively Many thanks in advance Darren -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com