Textbox Formatting

[Matthew W]

Hi
I'm writing an application in Access 2000 and I would like the user to be
able to format text within a textbox (or a similar control). Items such as
bold, italic, bullet points would be useful. Is there any control that can do
this within Access 2000 VBA or extending the textbox control at all?

Thanks
Matthew

 

[Dymondjack]

I believe that as long as a standard formatting toolbar can be used during
runtime, your users can format the text using that. I haven't gotten that
involved with this particular end of access but as far as I know as long as
you leave them access to the formatting toolbar you should be all set.

You might want to wait for someone more experienced to answer though... this
is little better than a guess for me.

 

[John Spencer]

To do this you need an RTF (Rich Text Format) control. Stephen Lebans
has one at his site for free.
www.lebans.com

You can search for the sample database and download on his site. The
application requires the installation of a dll in order to have the
ability to bold, italic, underline, etc.

There are also commercial products (search for them) that should give
you this ability.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Matthew W]

Hi
Thanks for that. I'm also wondering about saving the RTF data to a SQL
database. Will this control do that correctly?

Thanks again.
Matthew

 

[John Spencer]

It has for me.

What it saves (in a memo field usually) is the text and the rtf encoding
for the text. Since the contents of a field grow when the rtf encoding
occurs you are best off using a memo field or a field that is much
larger than the actual text you want to store.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================