Controlling font within a string

[Samantha]

Hi all, I have spent the better half of the afternoon researching how to accomplish controlling a bold font in a string I am building and sending to Excel.

' set text for safety hazards and controls
Concretetxt = "Concrete Demolition & vbCrLf & Hazards - dust, flying debris and skin Irritation. & vbCrLf & Control - Respirator, goggles, gloves, inspect equipment prior to use."
Excavationtxt = "Excavations & vbCrLf & Hazards - Damage to underground wires, collapse, falling materials/equipment. & vbCrLf & Control - Ensure utilities have been marked and hand dig when in close proximity, shore properly, Keep clear when lowering materials."

This is a sample of how the strings will build. I will select a task like Concrete Demolition and string it together with other tasks I would like "Concrete Demolition" in bold with the blurb following it then the next task would follow with a bold heading.

My thought is now that it may be easier to control by putting this data into a table instead of building the strings.
Thoughts and suggestions please?

 

[CJ_London]

depends which version of access your are using. 2003 and earlier use rtf and 2007 and later use html

either way, your field needs to be a memo (or longtext for 2013) and the text format set to rich text

I have no idea whether this will export successfully to excel - if you are using 2007 or later I think it will work, but never tried it so cannot confirm

 

[Samantha]

Thanks for the response CJ,
I am using 2010 and just purchased 2013 to explore web apps. The db works fine in both. The function exporting to excel works fine for every other field even multi-selection although I haven't tried exporting the memo field. I will play with it before I get to deep. Thanks for the guidance.