Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format Sub-Report Using "With Statements"

Status
Not open for further replies.

AverageBear

Technical User
Feb 2, 2000
6
US
To eliminate white space in a sub-report I'm using a VBA module. Problem is, all my text is now the same style and size. I need to have different fonts in different sizes. Can I use "with" statements, and is so, how? Here's approximately how the sub-report should look:

SPECIFIC KNOWLEDGE AND EXPERTISE

.
[knowledge1]
.
.
.
.
[knowledge9]

Consulting firms: [consulting]

Here's a bit of the module I created:

Function KnowBlock$(KnowledgeIntro, Knowledge1,..., Knowledge9, ConsultFirms)

Dim A1$, A2$,...A11$, A12$, A13$, CR$

CR$ = Chr(13) & Chr(10)

A1$ = IIf(ISB(KnowledgeIntro), "", (KnowledgeIntro) & CR$ & CR$ &
CR$)

A2$ = IIf(ISB(Knowledge1), "", B1$ & (Knowledge1) & CR$)

KnowBlock$ = A1$ & A2$

End Function


The white spaces are eliminated, but now all the text is 10 point Times New Roman. I need to be able to format in the report with different fonts, add bullets, etc.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top