Font Control on a Access Report

[Guest]

I would like some help with this, hopefully, someone has been there and done
this.

I have a statement as follows:

It is REQUIRED that each school administrator provide to the Deptartment,
Items 1, 2, and 3 of Section D (Mystate Code Book 123.12.12.) to re-certify
an instructor every two years.

I would like to have the word REQUIRED in bold font along with the SECTION D
statement including information in ( ) parens...

Is there a way to do this within access, either via an unbound object Frame
or other source. I've tryed to create the text in Ms Word and save as a .doc
file, and even though the saved document is in Times New Roman font pitch 11
when created, it imports as though it is Times New Roman font pitch 8, the
bold stays in but I loose the size, which I want to keep as 11 all the way
through the document.

Any suggestions?

Thanks,

Robert

 

[Larry Linson]

You can't have different fonts within the same standard Text Box. The
Developer Editions of Office through version XP and (I believe) Visual
Studio Tools for Office 2003 System contain an ActiveX control called the
Rich Text Box that allows the kind of formatting you describe, but MVP
Stephen Lebans has created and made available, free, an ActiveX for
displaying Rich Text File format (.rtf) which you can download from his web
site, http://www.lebans.com.

Larry Linson
Microsoft Access MVP

 

[Guest]

Larry Linson,

Thanks for your response to my question. I've not checked out the rtf
option yet, but I was able to work around my plight by the following.

1st. I created a small Microsoft word document that contained all of the
text in the format that I needed bolded and spaced the way that I needed. I
had to use Font "Times New Roman" font size of 16, with page setup of
landscape mode and save this document to the same folder that the database
was in.

2nd. I imported the same saved document into my report form as an OLE
Unbound Object with the following parms: size=clip, OLE Classs=Microsoft
Word, OLE Type=embedded, and Class=Word Document.8.

The two steps above allowed me to have this document embedded into the
report (form letter) and have it properly print in Times New Roman font size
11, formatting. I'm not quite sure how it worked the way it did, but it save
some time and got the project completed.

I will be checking out the other version and see if it will do a better job
of formatting though.

Thanks Again

Robert Nusz