Manuela has attended:
Access VBA course
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
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
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
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
