Prev: Access 2007 PIVOT TABLE
Next: split form column order
From: Dave on 27 Apr 2010 09:46
I have a text\memo filed that has a box charter(s) in it. I do not remember
if it is a carriage return or whatever. Whats is the character and how do I
replace it?

Thanks

Dave
From: John W. Vinson on 27 Apr 2010 12:04
On Tue, 27 Apr 2010 06:46:01 -0700, Dave <Dave(a)discussions.microsoft.com>
wrote:

>I have a text\memo filed that has a box charter(s) in it. I do not remember
>if it is a carriage return or whatever. Whats is the character and how do I
>replace it?
>
>Thanks
>
>Dave

You'll need to find out what it is. My guess is that it's a linefeed Chr(10) -
it wouldn't hurt to make a backup of your database just in case, and run a
query

SELECT memofield, InStr([memofield], Chr(10))
FROM tablename
WHERE memofield LIKE "*" & Chr(10) & "*"

to see if it shows the records with the box and the position of the linefeed.
Count characters and see if it matches.

You could then run an Update query updating the memo field:

UPDATE tablename
SET memofield = Replace([memofield], Chr(10), "")

Note that if the field has legitimate carriage return-linefeed characters this
will do more harm than good!
--

John W. Vinson [MVP]
From: Jerry Whittle on 27 Apr 2010 12:07
SELECT YourTable.YourField,
Replace([YourTable]![YourField],Chr(13)," ") AS WO_Characters
FROM YourTable
WHERE (((YourTable.YourField) Like "*" & Chr(13) & "*"));

Use something like above and replace the 13 with the various non-prining
ASCII characters. 13 and 10 are good places to start.

Next make a backup of the database. You might even want to make a copy for
testing. Change the 13 below to the value you fine above. This update query
will replace it with a space.

UPDATE YourTable
SET YourTable.YourField
= Replace([YourTable]![YourField],Chr(13)," ");
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Dave" wrote:

> I have a text\memo filed that has a box charter(s) in it. I do not remember
> if it is a carriage return or whatever. Whats is the character and how do I
> replace it?
>
> Thanks
>
> Dave
 | 
Pages: 1
Prev: Access 2007 PIVOT TABLE
Next: split form column order