Heenan, Lambert
Lambert.Heenan at AIG.com
Wed Feb 8 15:49:59 CST 2006
Doh!!!! Of course I did! :-) Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Wednesday, February 08, 2006 4:37 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Need help On 8 Feb 2006 at 15:25, Heenan, Lambert wrote: > Extracting the text in positions 3 through 6 is easy... > > txtSomeTextVariableOrSomeTextControl = Mid([Event Number],3,6) > Of course you meant to say "Mid([Event Number],3,4)" and just mistyped it :-) -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com