The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » access visual basic training - Format bold

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

access visual basic training - Format bold

Resolved · Low Priority · Version Standard

ReplyThu 20 Dec 2007, 16:38Delegate Manuela said...

Format bold

Is it possible to build up a character string and make part of that string bold?

I was hoping that maybe I could concatenate a code for bold to some previous concatenated fields (and text) and then at the end of what needed to be bold I could then concatenate a code to switch it off

No rush for this
Hope my explanation has not been confusing!!

Thanks
Manuela

For upcoming training course dates see: Pricing & availability

ReplyTue 29 Jan 2008, 12:30Trainer Carlos said...

Format Sections of a String as Bold

Hi Manuela

You cannot bold a variable or part of a string while its a variable, so I'm showing you how to do it after it is placed in a cell.

The code below takes the phrase:

Hello My Name is Carlos. Welcome to Excel VBA

in Range ("A1") and bolds the words "Carlos" and "Excel"

The default code line for this is:

Rng.Characters(Start, Length).Font.Bold = True

The Bracket sets the Start and Length of the section to be made Bold

Sub MakePartOfStringBold()

Dim Rng As Range

Set Rng = ActiveSheet.Range("A1")

Rng.Characters(18, 6).Font.Bold = True 'Bolds "Carlos"

Rng.Characters(37, 5).Font.Bold = True 'Bolds "Excel"

End Sub

Hope this helps

Carlos

ReplyThu 7 Feb 2008, 12:27Delegate Manuela said...

RE: Format Sections of a String as Bold

Sorry for delay in getting back to this.

Thanks for this. Have got this working in Excel but would you know of anything like this that works in Access Reports as my string that I am building up is being output to an Access Report?

Many thanks

Manuela

ReplyThu 28 Feb 2008, 15:26Delegate Manuela said...

RE: Format bold

Hello

My further question seems to have been lost in the ether! I was wondering if you could think of a way to do this in Access reports as the string with the bold in it is needed to output bibliographies?

Thanks again
and regards

Manuela

VBA articles

· A Helping Hand For Your Business, With VBA And Microsoft Office
· OOPS Visual Basic Did It Again
· Trigger Happy In Excel VBA
· If It's Not Broken Why Should You Fix It? Find Out With VBA
· VBA: It's Easy To Record Macros In Excel 2007

Vba tip:

Good coding practice

It is important that you always comment the VBA code that you write. By doing this it will make the code much easier to read, as both yourself and other people will be able to see what the code is doing or meant to be doing. This is very important if there is more than one person who writes code in the company as you may have different styles of coding and may not really understand what the other person is trying to do. Also if you write some code and then do not touch it for a year or so you may actually forget what it is meant to be doing. so it is very important to include comments throughout your code and try and make sure that they are as useful as possible

View all VBA hints and tips

How do you create an action query?

» Forum post: Create action query

A. First, note ID number of the task you want to link to (predecessor). Then, in the predecessor column of the task you want to link to (successor), type the predecessor task's ID number.
b. The link will be a Finish to Start (the default type).
c. Or y...