force a font name and font size in report

[Guest]

I am using Access 2007 & rich text format. I copy & paste course
descriptions from emails into an Access database. There are as many font
types as there are emails. Is there a way to force the Access report to
display and print the field DESCRIPTION using only one font name & size; i.e.
Times New Roman and size 10?

 

[Allen Browne]

Try the PlainText() function.

For example the ControlSource of your text box might be:
=PlainText([Description])

Be sure to change the Name property of the text box first.
Access gets confused if it has the same name as a field, but is bound to
something else.

 

[Guest]

Thanks Allen, but I need the rich text (at least if I'm understanding this
correctly) because I need to use italics for book titles mentioned & bold for
certain emphasis, etc. Doing what you suggest would negate all that, correct?

Try the PlainText() function.

For example the ControlSource of your text box might be:
=PlainText([Description])

Be sure to change the Name property of the text box first.
Access gets confused if it has the same name as a field, but is bound to
something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am using Access 2007 & rich text format. I copy & paste course
descriptions from emails into an Access database. There are as many font
types as there are emails. Is there a way to force the Access report to
display and print the field DESCRIPTION using only one font name & size;
i.e.
Times New Roman and size 10?

 

[Allen Browne]

So you do want rich text?
But only some of the rich text tags?
And you want to strip out other tags?
Selectively?

Sounds like you have function to write to remove the particular tags you
want to get rid of. Access doesn't do this for you.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen, but I need the rich text (at least if I'm understanding this
correctly) because I need to use italics for book titles mentioned & bold
for
certain emphasis, etc. Doing what you suggest would negate all that,
correct?

Try the PlainText() function.

For example the ControlSource of your text box might be:
=PlainText([Description])

Be sure to change the Name property of the text box first.
Access gets confused if it has the same name as a field, but is bound to
something else.

I am using Access 2007 & rich text format. I copy & paste course
descriptions from emails into an Access database. There are as many
font
types as there are emails. Is there a way to force the Access report
to
display and print the field DESCRIPTION using only one font name &
size;
i.e.
Times New Roman and size 10?

 

[Guest]

I want it to ALWAYS be Times New Roman and 10 font size, but I need bold &
italics also (which should still be in Times New Roman and font size 10).

So you do want rich text?
But only some of the rich text tags?
And you want to strip out other tags?
Selectively?

Sounds like you have function to write to remove the particular tags you
want to get rid of. Access doesn't do this for you.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen, but I need the rich text (at least if I'm understanding this
correctly) because I need to use italics for book titles mentioned & bold
for
certain emphasis, etc. Doing what you suggest would negate all that,
correct?

Try the PlainText() function.

For example the ControlSource of your text box might be:
=PlainText([Description])

Be sure to change the Name property of the text box first.
Access gets confused if it has the same name as a field, but is bound to
something else.

I am using Access 2007 & rich text format. I copy & paste course
descriptions from emails into an Access database. There are as many
font
types as there are emails. Is there a way to force the Access report
to
display and print the field DESCRIPTION using only one font name &
size;
i.e.
Times New Roman and size 10?