RTF ActiveX Control

[Guest]

Stephen Lebans & Marshall Barton & any other Guru out there....,

First let me say thanks for contributing to this post. Perhaps I have
bitten off more than I can chew but I believe Access can do what I need
done.......I have reviewed the RTF function and it is a great feature and I
will definately use it in certain parts of this project.

Let me clarify my earlier post by explaining my project.

I am attempting to create a letter generating database for a medical group.
It will require the user to select a 'healthplan'(from a combo box) and
'letter reason' (also from a combo box). In
some cases based on the reason for the letter, certain additional information
may be necessary which will be entered into a text box by the user. This
information must be in bold.

These reasons and additional text box values need to be concatenated. As of
yet, I have found no way to concatenate the RTF value of a control with the
contents of either another RTF control or a separate text box on a form.
Ideally, embedded text boxes and/or RTF controls in an RTF control would
work...I think

Am I missing something?

Thanks in advance for your thoughts....

 

[Stephen Lebans]

Greg I do not see the reason why you have to use an RTF control if the
entire contents of the "additional information" TextBox need to be
bolded. RTF controls are requried when you must mix character formatting
within a single multiple line TextBox.

Do the multiple TextBox controls have to be cocatentated for appearance
reasons, ie. must appear as a single paragraph?

--

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

 

[Guest]

Stephen,

Thanks for getting back with me...

In some cases, entire blocks will be bold and in others it isn't. Sometimes
just the manually entered portion has to be in bold.

In answer to your other question, yes these values need to be concatenated
for appearance.

To give you an idea of what I am trying to do, open this link. It lists
denial reasons for one type of denial only (currently 67). Notice that in
the 'Denial Reason' column for certain reasons, a manual insertion is
required. In most cases it must be bold.

http://www.iceforhealth.org/library/documents/Cvr Ltr with DENIAL REASON MATRIX (4.21.03)(1).doc

In an effort to streamline the process and reduce human error, I am hoping
to prompt users for those entries when necessary and prevent them from
touching any other part of the letter to maintain the integrity of the letter
structure. Healthcare like most other industries seems to be getting more
complicated and more regulated. There are 50 appearance and content
different audit points for a letter that have to be met when healthplans
(Blue Cross, Blue Shield etc) perform their annual compliance audits. It's a
small nightmare.

But as you know, the fewer choices required by a human, the better my
chances for passing an audit.

Hope to hear from you soon, and again thanks for your reply.

Greg

 

[Stephen Lebans]

You will have to use an RTF control wherever mixed formatting within a
paragraph is required.

I see two possible solutions.

1) Use Automation with MS Word. The docs would be setup with Bookmarks
for where you want to replace the "INSERT HERE" instructions with the
users choice of provider/whatever.

2) Do everything in Access. Since there are no CANGROW issues here,
multiple RTF controls can be used. RTF controls expose methods to
insert/replace text and apply formatting. The coding is easy once you
get up to speed.

There's nothing that complex about the app you are building, just a lot
of work initially to get the app up and running. If you are not an
experienced developer, I have a few fellow MVP's that I could reccommend
to you who supply consulting services for development work.

--

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

 

[Guest]

Stephen,

I would like to keep this within Access. At this point, this is my only
real road block on this project. I would definately consider talking with
someone you recommend about getting this piece to work. It might be easier
to continue this conversation via email.......... Mine is
(e-mail address removed). Either way, at this point this need is beyond my own
abilities....but I am a quick learner...

Thanks again for your assistance...

Greg