Storing text with tab characters

[DaveF]

I am copying some text from notepad and storing it in a Access 2000 by
pasting it into a textbox on a form. The controlsource for the textbox is a
field of datatype memo.

If there are tabs within the text I am storing, they display in the textbox
as two dark vertical bars preceeding the first character in the paragarph.
These tab "characters" display as a square box when printed to a report.

How can I get rid of these "tab characters?"

I am not so interested in preserving them in the database or even how they
display on the form. However, I do need to get a "clean" report (i.e., as
text-only without any special characters).

Besides manually removing all tabs before I store the text, can anyone
suggest a good way to handle this?

Thanks
Dave

 

[Van T. Dinh]

Use an UPDATE Query with the Replace() function to replace the Tab character
Chr(9)??? with the empty String.

Beware that there is a bug using Replace in Query in A2K (not sure whether
is was fixed by Service Releases / Service Packs) so you may need to write a
wrapper function for Replace to be able to use Replace() in the Query.

See MichKa's article:

http://www.trigeminal.com/usenet/usenet001.asp?1033