No Full Justification With Access 2007 Rich Text Property?

Neil

Just found out that the Microsoft Rich Textbox does not support full text
justification, since it's based on Version 1.0 of the RichEdit Window Class,
and full text justification is only available in versions 3.0 or later of
the class.

However, also just found out that the new Rich Text property in Access 2007
ALSO does not support full text justification! This seems incredible, that
MS would create a brand new application, and not provide rich text full text
justification, when that's been around since version 3.0 of the RichEdit
Window Class. Just seems incredible.

So, while I was thinking about upgrading to Access 2007 in part to be able
to use the built-in Rich Text property, now I don't know if that would work
for me, since I absolutely need full text justification. (Documents I'm
creating through rich text have to have justified paragraphs.)

So, two questions:

1) Am I mistaken about Access 2007? It really doesn't support full text
justification in rich text controls? That seems incredible.

2) What other options are there, if one has to have full justification with
a rich textbox?

Thanks!!

Neil

Jun 13 '07 #1

Rick Brandt

Neil wrote:

Just found out that the Microsoft Rich Textbox does not support full
text justification, since it's based on Version 1.0 of the RichEdit
Window Class, and full text justification is only available in
versions 3.0 or later of the class.

However, also just found out that the new Rich Text property in
Access 2007 ALSO does not support full text justification! This seems
incredible, that MS would create a brand new application, and not
provide rich text full text justification, when that's been around
since version 3.0 of the RichEdit Window Class. Just seems incredible.

So, while I was thinking about upgrading to Access 2007 in part to be
able to use the built-in Rich Text property, now I don't know if that
would work for me, since I absolutely need full text justification.
(Documents I'm creating through rich text have to have justified
paragraphs.)
So, two questions:

1) Am I mistaken about Access 2007? It really doesn't support full
text justification in rich text controls? That seems incredible.

2) What other options are there, if one has to have full
justification with a rich textbox?

Thanks!!

Neil

While I don't know the specific answers you are looking for some enlightenment
might come from the knowledge that Access 2007's "Rich Text" is actually HTML
and not RT at all.

On the surface I see no reason why that shouldn't allow it to support full
justification though since HTML (in web pages) does.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Jun 13 '07 #2

Neil

Well, the first reason I concluded that it doesn't support full
justification is because the toolbar that's available when you're in a rich
text textbox in Access 2007 has buttons for left justification, right
justification, and center justification -- but no button for full
justification. Same with the ribbon that pops up when you select text in a
rich text textbox.

Figuring that maybe they just left that out because it wasn't commonly used,
I went into the code module to see what properties were available. To my
dismay, I didn't even see any properties for setting formatted text in a
rich text textbox. So I went to online help, went to MSDN, went to a lot of
places, and didn't see anything about being able to set rich text
programmatically in Access 2007.

So I'm left thinking that that's not possible; that it's just a user
control, but it can't be manipulated in code. That would be very
unfortunate.

Now, I haven't used Access 2007. I've only played with it a couple of times.
So I could be totally wrong. There might be a way to manipulate a rich text
textbox in Access 2007. But I don't see it.

So I'm left with no full justification button from the user's side. And no
(apparent) properties for setting justification (or any other rich text
settings) on the code side. Doesn't look very good so far.

HTML is fine, as long as it can save to a doc that can be read by Word. But
I need full justification (and the ability to manipulate the control in
code).

Thanks,

Neil
"Rick Brandt" <ri*********@hotmail.comwrote in message
news:V2*****************@newssvr22.news.prodigy.ne t...

Neil wrote:

>Just found out that the Microsoft Rich Textbox does not support full
text justification, since it's based on Version 1.0 of the RichEdit
Window Class, and full text justification is only available in
versions 3.0 or later of the class.

However, also just found out that the new Rich Text property in
Access 2007 ALSO does not support full text justification! This seems
incredible, that MS would create a brand new application, and not
provide rich text full text justification, when that's been around
since version 3.0 of the RichEdit Window Class. Just seems incredible.

So, while I was thinking about upgrading to Access 2007 in part to be
able to use the built-in Rich Text property, now I don't know if that
would work for me, since I absolutely need full text justification.
(Documents I'm creating through rich text have to have justified
paragraphs.)
So, two questions:

1) Am I mistaken about Access 2007? It really doesn't support full
text justification in rich text controls? That seems incredible.

2) What other options are there, if one has to have full
justification with a rich textbox?

Thanks!!

Neil

While I don't know the specific answers you are looking for some
enlightenment might come from the knowledge that Access 2007's "Rich Text"
is actually HTML and not RT at all.

On the surface I see no reason why that shouldn't allow it to support full
justification though since HTML (in web pages) does.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Jun 13 '07 #3

david12

On Jun 13, 4:59 am, "Neil" <nos...@nospam.netwrote:

Just found out that the Microsoft Rich Textbox does not support full text
justification, since it's based on Version 1.0 of the RichEdit Window Class,
and full text justification is only available in versions 3.0 or later of
the class.

However, also just found out that the new Rich Text property inAccess2007
ALSO does not support full text justification! This seems incredible, that
MS would create a brand new application, and not provide rich text full text
justification, when that's been around since version 3.0 of the RichEdit
Window Class. Just seems incredible.

So, while I was thinking about upgrading toAccess2007 in part to be able
to use the built-in Rich Text property, now I don't know if that would work
for me, since I absolutely need full text justification. (Documents I'm
creating through rich text have to have justified paragraphs.)

So, two questions:

1) Am I mistaken aboutAccess2007? It really doesn't support full text
justification in rich text controls? That seems incredible.

2) What other options are there, if one has to have full justification with
a rich textbox?

Thanks!!

Neil

How about this:
1. Set the font to a fixed-width type (Lucida Sans Typewriter, Courier
New, etc.)
2. Make a function that strategically inserts spaces and vbCrLf for
your full justification needs. Arguments would be the text and maximum
character width and return value is the converted text (string).
3. Call that function when needed (OnCurrent and AfterUpdate of
textbox).
4. Might need an unbound textbox to hold resulting text.
Kinda crude but can be done and would give you control via code.
David

Jun 13 '07 #4

Neil

Well, thanks for the idea. But the text has to be Times Roman.

But, even if I used a fixed-width font, I'm not sure your idea would work.
In order to make the lines justified, I would more than likely have to add a
fraction of a space between words. If, say, there were 5 spaces left at the
end of the line and 8 spaces between words, I'd have to add 5/8 of a space
between each word. Don't think that can be done.

Thanks for the thought, though!

Neil
"david12" <da*********@yahoo.comwrote in message
news:11*********************@d30g2000prg.googlegro ups.com...

On Jun 13, 4:59 am, "Neil" <nos...@nospam.netwrote:

>Just found out that the Microsoft Rich Textbox does not support full text
justification, since it's based on Version 1.0 of the RichEdit Window
Class,
and full text justification is only available in versions 3.0 or later of
the class.

However, also just found out that the new Rich Text property inAccess2007
ALSO does not support full text justification! This seems incredible,
that
MS would create a brand new application, and not provide rich text full
text
justification, when that's been around since version 3.0 of the RichEdit
Window Class. Just seems incredible.

So, while I was thinking about upgrading toAccess2007 in part to be able
to use the built-in Rich Text property, now I don't know if that would
work
for me, since I absolutely need full text justification. (Documents I'm
creating through rich text have to have justified paragraphs.)

So, two questions:

1) Am I mistaken aboutAccess2007? It really doesn't support full text
justification in rich text controls? That seems incredible.

2) What other options are there, if one has to have full justification
with
a rich textbox?

Thanks!!

Neil

How about this:
1. Set the font to a fixed-width type (Lucida Sans Typewriter, Courier
New, etc.)
2. Make a function that strategically inserts spaces and vbCrLf for
your full justification needs. Arguments would be the text and maximum
character width and return value is the converted text (string).
3. Call that function when needed (OnCurrent and AfterUpdate of
textbox).
4. Might need an unbound textbox to hold resulting text.
Kinda crude but can be done and would give you control via code.
David

Jun 13 '07 #5