Prev: Referencing Forms
Next: Keep getting error from code
From: Dirk Goldgar on 6 Apr 2010 21:42
"David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in message
news:Xns9D52DB8DEDCA0f99a49ed1d0c49c5bbb2(a)74.209.136.99...
> "Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in
> news:443FED60-045F-4887-8827-4AD3B7FF1565(a)microsoft.com:
>
>> (though you'd need to remove the <div> and </div> tags).
>
> Isn't there a function in there to return HTML memo fields as plain
> text?


I don't know -- I haven't explored that aspect of Access 2007 yet. I'm a
little puzzled, because Dale said the memo field was set to Plain Text. I
wonder if it was previously set to Rich Text, had some data entered that
way, and then was changed to Plain Text.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: Dirk Goldgar on 8 Apr 2010 11:41
"David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in message
news:Xns9D52DB8DEDCA0f99a49ed1d0c49c5bbb2(a)74.209.136.99...
>
> Isn't there a function in there to return HTML memo fields as plain
> text?


There is; it's called PlainText(). You pass it the value of the rich text
field, and it strips out the HTML tags and returns the plain-text version of
it. Oddly, there doesn't seem to be a RichText() function to take a
plain-text string, wrap it in <div></div> tags, and convert any necessary
embedded HTML elements (such as left-angle-brackets) into character codes.
You'd think there ought to be something like that.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

First  |  Prev  | 
Pages: 1 2 3
Prev: Referencing Forms
Next: Keep getting error from code