Bold & Italic formating in ltr

[Jenner]

I have a letter where some of the words within the text
box for a paragraph needs to be formatted bold & italics
while a field included in the letter needs to be bold.
All other text is the default. How can I format these
within the overall text box for bold and italics?

I did it with currency as: ="Thank you for your donation
of "&Format([DepositAmount],"Currency")"

Thx

 

[Stephen Lebans]

You cannot accomplish mixed formatting within the standard Access
TextBox control. You will require a Rich Text ActiveX control. Further
if the data already exists you would have to programmatically, or more
likely, manually format the data within the Rich TextBox control and
save each record.

--

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

 

[Jenner]

But if I can do it within the same text box for dates and
currency, why not text?

-----Original Message-----
You cannot accomplish mixed formatting within the standard Access
TextBox control. You will require a Rich Text ActiveX control. Further
if the data already exists you would have to programmatically, or more
likely, manually format the data within the Rich TextBox control and
save each record.

--

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

I have a letter where some of the words within the text
box for a paragraph needs to be formatted bold & italics
while a field included in the letter needs to be bold.
All other text is the default. How can I format these
within the overall text box for bold and italics?

I did it with currency as: ="Thank you for your donation
of "&Format([DepositAmount],"Currency")"

Thx

.

 

[Stephen Lebans]

Jenner I have given you the only answer that is possible to solve your
issue. If you don't like it, well sorry, but there is nothing I can do
about it.

--

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

But if I can do it within the same text box for dates and
currency, why not text?

-----Original Message-----
You cannot accomplish mixed formatting within the standard Access
TextBox control. You will require a Rich Text ActiveX control. Further
if the data already exists you would have to programmatically, or more
likely, manually format the data within the Rich TextBox control and
save each record.

--

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

I have a letter where some of the words within the text
box for a paragraph needs to be formatted bold & italics
while a field included in the letter needs to be bold.
All other text is the default. How can I format these
within the overall text box for bold and italics?

I did it with currency as: ="Thank you for your donation
of "&Format([DepositAmount],"Currency")"

Thx

.

 

[Rick Brandt]

It's not that I'm challenging your answer but trying to
understand the programming logic being applied that
allows different formats to sometimes be applied. Is it
because it is text while the other examples used are
dates and currency? Understanding the logic helps me
better understand the limitations.

These are completely different issues. The formatting options that change the
appearance depending on the data when displaying numbers is based on a property of
the data in the control in its entirety. If the number is positive use this
formatting, if zero use this, if negative use this, etc.. While the format can
change for various values in the control, the formatting is still applied to all of
the data. That is not the same as having a long string of text in a TextBox and
trying to have Access look for particular words in the control and apply specific
formatting to only those words.