[AccessD] Access 2007 rtf fields

Doug Steele dbdoug at gmail.com
Mon Aug 13 15:50:52 CDT 2012


Thanks, Jim.  We'd definitely need over 360 characters.  In addition,
the client wants to do equation editing, so without sub and
superscripts the MS HTML 'rich text' isn't going to work.

Doug

On Mon, Aug 13, 2012 at 10:11 AM, Jim Dettman <jimdettman at verizon.net> wrote:
>
>  By the way, watch out with RTF formatted in HTML; there is a locking bug
> when it gets over a page (which is around 360 characters in the RTF).
>
>  When you hit it, you simply can't add anything more as it always tells you
> the record is locked by another user even if it's not.  I turned it into
> Microsoft over a year ago, but never heard anything back and it's never been
> fixed that I'm aware of.
>
>  The work a round is to not use HTML formatting.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
> Sent: Monday, August 13, 2012 12:35 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access 2007 rtf fields
>
> Thanks, Jack.
>
> This article confirms what I was discovering by experiment - too bad I
> didn't find it before I wasted an hour or so.  I guess that when MS
> says 'Rich Text', it means whatever MS wants it to at the time!
>
> Doug
>
> On Sun, Aug 12, 2012 at 5:06 PM, jack drawbridge <jackandpat.d at gmail.com>
> wrote:
>> Found this on Techrepublic. I hope it's may be useful.
>>
> http://www.techrepublic.com/blog/msoffice/how-to-work-with-rich-text-in-acce
> ss-2007-and-2010/4795
>> Good luck.
>> On Sun, Aug 12, 2012 at 10:25 AM, Doug Steele <dbdoug at gmail.com> wrote:
>>
>>> Thanks Gustav and (other) Doug:
>>>
>>> Can you point me at any detailed reference for this HTML 'rich text'?
>>>
>>> Thanks,
>>> Doug
>>>
>>> On Sun, Aug 12, 2012 at 1:13 AM, Gustav Brock <gustav at cactus.dk> wrote:
>>> > Hi Doug
>>> >
>>> > The "rich text" fields of A2007+ are not RichText (rtf) but HTML.
>>> >
>>> > To use true rtf you'll have to use the RTF-control of A97-A2003 or VB.
>>> > This can, however, be hard obtain and license but it is possible.
>>> >
>>> > /gustav
>>> >
>>> >
>>> >>>> dbdoug at gmail.com 11-08-12 20:42 >>>
>>> > Hello all:
>>> >
>>> > Has anyone used rft fields in Access 2007?  Are the formats quite
>>> > limited compared to 'real' rtf, like Word uses?  In particular I would
>>> > like to format subscripts and superscripts.  I'm quite confused right
>>> > now.  Here's what I've found:
>>> >
>>> > 1. Inserting real rtf formatting codes like "{{\rtf1 This is some {\b
>>> > bold} text} doesn't work (either pasting direct or inserting with
>>> > VBA).  The field treats the formatting codes as text.
>>> > 2. Inserting (some) html codes does work: "This is <b>bold
>>> > text</bold>" formats correctly. "This is supposed to be a
>>> > <sub>subscript</sub>" doesn't.
>>> > 3. Copying and pasting rtf formatted code from Access 2007 to Word 2007
>>> works.
>>> > 4. Copying and pasting rtf formatted code from Word to Access works
>>> > only for the limited selection of formats shown in the Access
>>> > formatting toolbar, but not for subscripts etc.
>>> >
>>> > Is is possible to use real rtf codes?
>>> > What's with the html formatting?  Is there a list somewhere of html
>>> > codes that work?
>>> >
>>> > Thanks,
>>> > Doug
>>> >
>>> > --
>>> > AccessD mailing list
>>> > AccessD at databaseadvisors.com
>>> > http://databaseadvisors.com/mailman/listinfo/accessd
>>> > Website: http://www.databaseadvisors.com
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


More information about the AccessD mailing list