How do I display tab-delimited text in a memo field?

[Guest]

I have data extracted from a remote database using ODBC which has one field
of type MEMO. In this field the data is formated using tabs (ie chr(9)) . I
store this field locally in my database however when I display it in a form
the formatting is lost (ie the tab character is displayed as a single
character).

I have written some VBA to identify the tab character and replace it with
spaces but this is no use when subsequent lines of text are supposed to be
aligned.

 

[Douglas J. Steele]

Text boxes are incapable of dealing correctly with tabs.

You could try using an RTF control (such as the free one Stephen Lebans has
at http://www.lebans.com/richtext.htm)