[AccessD] tabs in memo fields

Jim/Roz

http://support.microsoft.com/?kbid=210433

..hth :)

William Hindman


----- Original Message ----- 
From: "Roz Clarke" <roz.clarke at donnslaw.co.uk>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Wednesday, January 05, 2005 4:23 AM
Subject: RE: [AccessD] tabs in memo fields


> Hi Jim
>
> I hope some bright spark who actually slept last night will come up with 
> an
> elegant solution because the only thing I can come up with at the moment 
> is
> rather clunky.
>
> Do an INSTR to find the first tab character (CHR(9) iirc). Keep doing this
> on the same memo until you don't find a tab, then move on to the mext 
> memo.
> You could use a flag to indicate whether a tab was found on the last pass 
> or
> not, so that your code knows whether to look at the same memo again or 
> move
> on to the next one.
>
> Untested, ungraceful... if there's a neat way of doing it I'd like to know
> too
>
> Roz
>
> -----Original Message-----
> From: Jim Lawrence [mailto:accessd at shaw.ca]
> Sent: 05 January 2005 07:52
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] tabs in memo fields
>
>
> Hi All:
>
> It seems simple but, is there a way to replace tab characters within a 
> memo
> field using a query or function? Note, memo field can be many hundreds of
> characters.
>
> TIA
> Jim
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


--------------------------------------------------------------------------------


>
> The contents of this message and any attachments are the property of Donns 
> Solicitors
> and are intended for the confidential use of the named recipient only. 
> They may be legally
> privileged and should not be communicated to, or relied upon, by any other 
> party without
> our written consent.  If you are not the addressee, please notify us 
> immediately so that we
> can make arrangements for its return.  You should not show this e-mail to 
> any person or
> take copies as you may be committing a criminal or civil offence for which 
> you may be
> liable.  The statement and opinions expressed in this e-mail message are 
> those of the
> writer, and do not necessarily represent that of Donns Solicitors. 
> Although any files attached
> to this e-mail will have been checked with virus protection software prior 
> to transmission,
> you should carry out your own virus check before opening any attachment.
> Donns Solicitors does not accept any liability for any damage or loss 
> which may be caused
> by software viruses...
>


--------------------------------------------------------------------------------


> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>