RTF text box

[LucB]

I want to write formatted text in a text box on a form, dynamically. Purpose: to write botanical plant names like

Hydrangea macrophylla (Thunb.) Ser. subsp. macrophylla 'Blue Wave'

where [Hydrangea macrophylla] = italic, [(Thunb.) Ser. subsp.] = regular, [macrophylla] = italic, ['Blue Wave'] = regular.

Should I use an ActiveX component, and if so, where to find a <simple> specimen? I don't need many bells and whistles, a simple text box that I can fill using VBA will do.

 

[Marshall Barton]

I want to write formatted text in a text box on a form, dynamically. Purpose: to write botanical plant names like

Hydrangea macrophylla (Thunb.) Ser. subsp. macrophylla 'Blue Wave'

where [Hydrangea macrophylla] = italic, [(Thunb.) Ser. subsp.] = regular, [macrophylla] = italic, ['Blue Wave'] = regular.

Should I use an ActiveX component, and if so, where to find a <simple> specimen? I don't need many bells and whistles, a simple text box that I can fill using VBA will do.

Try the one at www.lebans.com

 

[LucB]

Thanks. I installed the ActiveX component. Now where can I find info on how
to make it work with it? Properties, methods etc., or maybe an example on
how to program it in VBA? I regret I'm not an expert...

I want to write formatted text in a text box on a form, dynamically. Purpose: to write botanical plant names like

Hydrangea macrophylla (Thunb.) Ser. subsp. macrophylla 'Blue Wave'

where [Hydrangea macrophylla] = italic, [(Thunb.) Ser. subsp.] = regular, [macrophylla] = italic, ['Blue Wave'] = regular.

Should I use an ActiveX component, and if so, where to find a <simple>

specimen? I don't need many bells and whistles, a simple text box that I can
fill using VBA will do.

 

[Marshall Barton]

Thanks. I installed the ActiveX component. Now where can I find info on how
to make it work with it? Properties, methods etc., or maybe an example on
how to program it in VBA? I regret I'm not an expert...

Stephen usually explains things in a code module and/or the
example forms/reports.
--
Marsh
MVP [MS Access]

I want to write formatted text in a text box on a form, dynamically. Purpose: to write botanical plant names like

Hydrangea macrophylla (Thunb.) Ser. subsp. macrophylla 'Blue Wave'

where [Hydrangea macrophylla] = italic, [(Thunb.) Ser. subsp.] = regular, [macrophylla] = italic, ['Blue Wave'] = regular.

Should I use an ActiveX component, and if so, where to find a <simple>

specimen? I don't need many bells and whistles, a simple text box that I can
fill using VBA will do.

"Marshall Barton" wrote
Try the one at www.lebans.com

 

[LucB]

I noticed some extremely succinct code extracts on the site, but nothing
that can get me going. No overview of properties or methods AT ALL.

And as the author (Stephen Lebans) insists that the users of his code sort
things out via the newsgroups, I'm dutifully coming back to this forum. I
used some trial and error, and of course the first thing I got stuck with
were the 2 reported bugs, BackColor not persistent and First
character/action is discarded. For this second bug - which really annoys
me - there's a cryptic description of a workaround, which I can't convert
into code.

Conclusion: I'm about to give up. Please let me know if you have a
suggestion for a better documented ActiveX RTF control.

Thanks. I installed the ActiveX component. Now where can I find info on how
to make it work with it? Properties, methods etc., or maybe an example on
how to program it in VBA? I regret I'm not an expert...

Stephen usually explains things in a code module and/or the
example forms/reports.
--
Marsh
MVP [MS Access]

LucB wrote:
I want to write formatted text in a text box on a form, dynamically.

Purpose: to write botanical plant names like

Hydrangea macrophylla (Thunb.) Ser. subsp. macrophylla 'Blue Wave'

where [Hydrangea macrophylla] = italic, [(Thunb.) Ser. subsp.] =

regular,
[macrophylla] = italic, ['Blue Wave'] = regular.

Should I use an ActiveX component, and if so, where to find a <simple>

specimen? I don't need many bells and whistles, a simple text box that I can
fill using VBA will do.

"Marshall Barton" wrote
Try the one at www.lebans.com

 

[Stephen Lebans]

Luc just what do you expect for FREE? I included a sample MDB showing
how to use the control to display RTF on Forms and Reports. And that's
how the control started out, simply offering a free method to users to
allow them to show RTF in Access Forms and Reports. Eventually, users
started asking for me to add editing capabilities so I did. Developers
starting asking for programmatic control so I added support in this area
as well.

There is a built in Right Click menu exposing all of the common props
and methods to allow the user to format the contents of the control. No
external ToolBars required.
You can use the Object Browser to see the individual props and methods
if you require programmatic control.

The first character being dropped BUG for a new record also exists in
the FMS RTF control. The suggested solution is to Dirty the record in
the Current event.

As for the lack of persistence of the BackColor prop simply set it in
the Form's Load event.

I do not offer personalized Email support for the control simply because
the control is Free. I'm not going to give up my limited programming
time to offer support for a product that you never paid for. Complain
about the lack of Help files? Why don't you give up some of your time to
create one and post it here!

Finally, I agree that you should give up and not use my Free control.
FMS sells an excellent, full featured control for $299 US. Hands down it
is superior to my control. I hope you have better luck with the FMS
control
--

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

I noticed some extremely succinct code extracts on the site, but nothing
that can get me going. No overview of properties or methods AT ALL.

And as the author (Stephen Lebans) insists that the users of his code sort
things out via the newsgroups, I'm dutifully coming back to this forum. I
used some trial and error, and of course the first thing I got stuck with
were the 2 reported bugs, BackColor not persistent and First
character/action is discarded. For this second bug - which really annoys
me - there's a cryptic description of a workaround, which I can't convert
into code.

Conclusion: I'm about to give up. Please let me know if you have a
suggestion for a better documented ActiveX RTF control.

info on
how

to make it work with it? Properties, methods etc., or maybe an example on
how to program it in VBA? I regret I'm not an expert...

Stephen usually explains things in a code module and/or the
example forms/reports.
--
Marsh
MVP [MS Access]

LucB wrote:
I want to write formatted text in a text box on a form, dynamically.
Purpose: to write botanical plant names like

Hydrangea macrophylla (Thunb.) Ser. subsp. macrophylla 'Blue Wave'

where [Hydrangea macrophylla] = italic, [(Thunb.) Ser. subsp.] = regular,
[macrophylla] = italic, ['Blue Wave'] = regular.

Should I use an ActiveX component, and if so, where to find a

specimen? I don't need many bells and whistles, a simple text box

that I
can

 

[LucB]

Dear Mr Lebans

Your comments below show how much you care for non experts who try to find
their way in Access. I know your code is for free, and do accept possible
problems. However, if you yourself and others keep on mimicking "try Lebans
code" as the solution par excellence, I am pissed off if I can't find any
support. That's all.

LB

Luc just what do you expect for FREE? I included a sample MDB showing
how to use the control to display RTF on Forms and Reports. And that's
how the control started out, simply offering a free method to users to
allow them to show RTF in Access Forms and Reports. Eventually, users
started asking for me to add editing capabilities so I did. Developers
starting asking for programmatic control so I added support in this area
as well.

There is a built in Right Click menu exposing all of the common props
and methods to allow the user to format the contents of the control. No
external ToolBars required.
You can use the Object Browser to see the individual props and methods
if you require programmatic control.

The first character being dropped BUG for a new record also exists in
the FMS RTF control. The suggested solution is to Dirty the record in
the Current event.

As for the lack of persistence of the BackColor prop simply set it in
the Form's Load event.

I do not offer personalized Email support for the control simply because
the control is Free. I'm not going to give up my limited programming
time to offer support for a product that you never paid for. Complain
about the lack of Help files? Why don't you give up some of your time to
create one and post it here!

Finally, I agree that you should give up and not use my Free control.
FMS sells an excellent, full featured control for $299 US. Hands down it
is superior to my control. I hope you have better luck with the FMS
control
--

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

I noticed some extremely succinct code extracts on the site, but nothing
that can get me going. No overview of properties or methods AT ALL.

And as the author (Stephen Lebans) insists that the users of his code sort
things out via the newsgroups, I'm dutifully coming back to this forum. I
used some trial and error, and of course the first thing I got stuck with
were the 2 reported bugs, BackColor not persistent and First
character/action is discarded. For this second bug - which really annoys
me - there's a cryptic description of a workaround, which I can't convert
into code.

Conclusion: I'm about to give up. Please let me know if you have a
suggestion for a better documented ActiveX RTF control.

LucB wrote:

Thanks. I installed the ActiveX component. Now where can I find

info on
how

to make it work with it? Properties, methods etc., or maybe an example on
how to program it in VBA? I regret I'm not an expert...


Stephen usually explains things in a code module and/or the
example forms/reports.
--
Marsh
MVP [MS Access]




LucB wrote:
I want to write formatted text in a text box on a form, dynamically.
Purpose: to write botanical plant names like

Hydrangea macrophylla (Thunb.) Ser. subsp. macrophylla 'Blue Wave'

where [Hydrangea macrophylla] = italic, [(Thunb.) Ser. subsp.] = regular,
[macrophylla] = italic, ['Blue Wave'] = regular.

Should I use an ActiveX component, and if so, where to find a

specimen? I don't need many bells and whistles, a simple text box

that I
can

fill using VBA will do.


Try the one at www.lebans.com

 

[Stephen Lebans]

Where in the world will you find a product that offers free personalized
support when you paid nothing for the product?

Luc I missed the start of this thread. I always take the time to answer
inquiries here as to the use of my RTF control. Do a googlegroups
search. You will find very few threads on how to use my control that I
have not responded to.

Even if you purchase the FMS control you will be no further ahead.
Programmatic manipulation of RTF codes for plain text requires
programming...period. There are no set examples that I know of as code
must be created for each particular situation. If you have limited
experience in string parsing within VB and setting control props then
you have a steep learning curve ahead of you no matter which RTF control
you ultimately use.

The projects on my site are suggested quite often as the solution for
many common problems as in many cases they are the only solutions that
exist. Over the years I have purposely and specifically addressed those
issues in Access that users/developers have been unable to find
solutions for. The overwhelming majority of the solutions on my site
were written so that the implementation is as easy as possible for
beginners. Other solutions are clearly for the middle to advanced
developers and frankly of no use to non programmers.

Until I read your last post complaining about my lack of personalized
support and control shortcomings I was actually interested in your
issue. I just have been tied up lately because I too am in the hort
business and you know how busy it is at this time of the year.

The solution "par excellence" for this issue is for you to spend $299 US
and purchase the FMS control. Then you can call FMS Tech support and
perhaps someone will help you to develop the VBA code required to allow
for programmatic formatting of plain text.

Good Luck with your project.


--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

Dear Mr Lebans

Your comments below show how much you care for non experts who try to find
their way in Access. I know your code is for free, and do accept possible
problems. However, if you yourself and others keep on mimicking "try Lebans
code" as the solution par excellence, I am pissed off if I can't find any
support. That's all.

LB

"Stephen Lebans"

wrote in message news:[email protected]...

Luc just what do you expect for FREE? I included a sample MDB showing
how to use the control to display RTF on Forms and Reports. And that's
how the control started out, simply offering a free method to users to
allow them to show RTF in Access Forms and Reports. Eventually, users
started asking for me to add editing capabilities so I did. Developers
starting asking for programmatic control so I added support in this area
as well.

There is a built in Right Click menu exposing all of the common props
and methods to allow the user to format the contents of the control. No
external ToolBars required.
You can use the Object Browser to see the individual props and methods
if you require programmatic control.

The first character being dropped BUG for a new record also exists in
the FMS RTF control. The suggested solution is to Dirty the record in
the Current event.

As for the lack of persistence of the BackColor prop simply set it in
the Form's Load event.

I do not offer personalized Email support for the control simply because
the control is Free. I'm not going to give up my limited programming
time to offer support for a product that you never paid for. Complain
about the lack of Help files? Why don't you give up some of your time to
create one and post it here!

Finally, I agree that you should give up and not use my Free control.
FMS sells an excellent, full featured control for $299 US. Hands down it
is superior to my control. I hope you have better luck with the FMS
control
--

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

I noticed some extremely succinct code extracts on the site, but nothing
that can get me going. No overview of properties or methods AT ALL.

And as the author (Stephen Lebans) insists that the users of his

code
sort

things out via the newsgroups, I'm dutifully coming back to this forum. I
used some trial and error, and of course the first thing I got

stuck
with

were the 2 reported bugs, BackColor not persistent and First
character/action is discarded. For this second bug - which really annoys
me - there's a cryptic description of a workaround, which I can't convert
into code.

Conclusion: I'm about to give up. Please let me know if you have a
suggestion for a better documented ActiveX RTF control.

LucB wrote:

Thanks. I installed the ActiveX component. Now where can I find info on
how
to make it work with it? Properties, methods etc., or maybe an example on
how to program it in VBA? I regret I'm not an expert...


Stephen usually explains things in a code module and/or the
example forms/reports.
--
Marsh
MVP [MS Access]




LucB wrote:
I want to write formatted text in a text box on a form, dynamically.
Purpose: to write botanical plant names like

Hydrangea macrophylla (Thunb.) Ser. subsp. macrophylla 'Blue Wave'

where [Hydrangea macrophylla] = italic, [(Thunb.) Ser. subsp.] =
regular,
[macrophylla] = italic, ['Blue Wave'] = regular.

Should I use an ActiveX component, and if so, where to find

a

specimen? I don't need many bells and whistles, a simple text

box
that I

can
fill using VBA will do.


Try the one at www.lebans.com

 

[Ron Weiner]

Dear Stephen

About a year and a half ago we were looking to build an Access 2k app that
could handle Rich Text. We considered using your control, but decided to go
with FMS specifically for the support and assumed stability that we thought
a couple hundred bucks would buy us. So we took the plunge paid our monies
and started using the control in our project.

At the outset let me say for the record that FMS's support was "Top Notch".
Our calls, and Emails were answered promptly, by knowledgeable staff that
did everything they could to support us.

However. You knew there'd be a however. After chasing a myriad of problems
with the FMS TAM control for 8 months, we finally wound up ripping it out of
the app. We had a number of issues with the control some of which FMS said
there was nothing they could do about, because of the way that Microsoft
handled Active X controls in Access, or that the base control that they
wrapped with their interface (from Microsoft) did not support the
functionality we needed. In the end we discovered that removing the RTF
control made out app more stable, reduced the number of support calls we
received, and (the kicker) did not materially detract from the finished app.
In the end we were able to supply our customers with a stable, high
performance application, that still had satisfactory paper output. We are
happy, and what's more important OUR CUSTOMERS are happy.

I do not consider our foray into Access and the TAM control to be a total
loss. In fact I learned a hell of a lot about troubleshooting, workarounds,
and how to deflect customer complaints. The big lessons learned were:

1) Do NOT let your Access application rely on an active X control unless
there is absolutely NO OTHER OPTION! Versioning issues alone cause untold
lost troubleshooting man-hours.
2) Talk to your customer. The feature that they have on their tick list
MIGHT NOT BE CRITICAL for the job at hand. Discuss alternatives! Be sure
you understand their business and their needs.

Our app is currently successfully deployed to multiple customers. One
customer has nearly two hundred users using the app with almost no support
calls. In fact the only support call we got this week was to report a
misspelled word in a label control.

As for Luc, based on my experience I'd say the probability that he can
produce a scaleable, reliable, high performance Access application with an
RTF control (yours, FMS's, or anyone's) is astonishing close to zero if he
is a novice VBA guy.

As for me, while I have never used your stuff in any of our apps, I have
visited your web site, studied your code, and learned some good programming
tips, tricks, and ideas. I appreciate all you have done, and hopefully will
continue doing for the Access community. Thanks!!

Ron W

Where in the world will you find a product that offers free personalized
support when you paid nothing for the product?

Luc I missed the start of this thread. I always take the time to answer
inquiries here as to the use of my RTF control. Do a googlegroups
search. You will find very few threads on how to use my control that I
have not responded to.

Even if you purchase the FMS control you will be no further ahead.
Programmatic manipulation of RTF codes for plain text requires
programming...period. There are no set examples that I know of as code
must be created for each particular situation. If you have limited
experience in string parsing within VB and setting control props then
you have a steep learning curve ahead of you no matter which RTF control
you ultimately use.

The projects on my site are suggested quite often as the solution for
many common problems as in many cases they are the only solutions that
exist. Over the years I have purposely and specifically addressed those
issues in Access that users/developers have been unable to find
solutions for. The overwhelming majority of the solutions on my site
were written so that the implementation is as easy as possible for
beginners. Other solutions are clearly for the middle to advanced
developers and frankly of no use to non programmers.

Until I read your last post complaining about my lack of personalized
support and control shortcomings I was actually interested in your
issue. I just have been tied up lately because I too am in the hort
business and you know how busy it is at this time of the year.

The solution "par excellence" for this issue is for you to spend $299 US
and purchase the FMS control. Then you can call FMS Tech support and
perhaps someone will help you to develop the VBA code required to allow
for programmatic formatting of plain text.

Good Luck with your project.


--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

Dear Mr Lebans

Your comments below show how much you care for non experts who try to find
their way in Access. I know your code is for free, and do accept possible
problems. However, if you yourself and others keep on mimicking "try Lebans
code" as the solution par excellence, I am pissed off if I can't find any
support. That's all.

LB

"Stephen Lebans"

wrote in message news:[email protected]...

Luc just what do you expect for FREE? I included a sample MDB showing
how to use the control to display RTF on Forms and Reports. And that's
how the control started out, simply offering a free method to users to
allow them to show RTF in Access Forms and Reports. Eventually, users
started asking for me to add editing capabilities so I did. Developers
starting asking for programmatic control so I added support in this area
as well.

There is a built in Right Click menu exposing all of the common props
and methods to allow the user to format the contents of the control. No
external ToolBars required.
You can use the Object Browser to see the individual props and methods
if you require programmatic control.

The first character being dropped BUG for a new record also exists in
the FMS RTF control. The suggested solution is to Dirty the record in
the Current event.

As for the lack of persistence of the BackColor prop simply set it in
the Form's Load event.

I do not offer personalized Email support for the control simply because
the control is Free. I'm not going to give up my limited programming
time to offer support for a product that you never paid for. Complain
about the lack of Help files? Why don't you give up some of your time to
create one and post it here!

Finally, I agree that you should give up and not use my Free control.
FMS sells an excellent, full featured control for $299 US. Hands down it
is superior to my control. I hope you have better luck with the FMS
control
--

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


I noticed some extremely succinct code extracts on the site, but
nothing
that can get me going. No overview of properties or methods AT ALL.

And as the author (Stephen Lebans) insists that the users of his code
sort
things out via the newsgroups, I'm dutifully coming back to this
forum. I
used some trial and error, and of course the first thing I got stuck
with
were the 2 reported bugs, BackColor not persistent and First
character/action is discarded. For this second bug - which really
annoys
me - there's a cryptic description of a workaround, which I can't
convert
into code.

Conclusion: I'm about to give up. Please let me know if you have a
suggestion for a better documented ActiveX RTF control.

LucB wrote:

Thanks. I installed the ActiveX component. Now where can I find
info on
how
to make it work with it? Properties, methods etc., or maybe an
example on
how to program it in VBA? I regret I'm not an expert...


Stephen usually explains things in a code module and/or the
example forms/reports.
--
Marsh
MVP [MS Access]




LucB wrote:
I want to write formatted text in a text box on a form,
dynamically.
Purpose: to write botanical plant names like

Hydrangea macrophylla (Thunb.) Ser. subsp. macrophylla 'Blue
Wave'

where [Hydrangea macrophylla] = italic, [(Thunb.) Ser. subsp.] =
regular,
[macrophylla] = italic, ['Blue Wave'] = regular.

Should I use an ActiveX component, and if so, where to find a
<simple>
specimen? I don't need many bells and whistles, a simple text box
that I
can
fill using VBA will do.


Try the one at www.lebans.com