If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
force a font name and font size in report
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? |
#2
|
|||
|
|||
force a font name and font size in report
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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Donna" wrote in message ... 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? |
#3
|
|||
|
|||
force a font name and font size in report
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? "Allen Browne" wrote: 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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Donna" wrote in message ... 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? |
#4
|
|||
|
|||
force a font name and font size in report
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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Donna" wrote in message ... 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? "Allen Browne" wrote: 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. "Donna" wrote in message ... 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? |
#5
|
|||
|
|||
force a font name and font size in report
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). "Allen Browne" wrote: 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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Donna" wrote in message ... 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? "Allen Browne" wrote: 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. "Donna" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|