Changing Font to Bold

[tikrit]

Hello,
I have the following expression in a calculated Field in Access 2010.
>
="We certify that Mr." & " " & [Name] & " " & "Has Graduated"
>


And it works really fine. It takes the name from the [Name] field.
I want to know how make the name with bold font alone? Is there any method or any code to write in the Expression Builder?
Thanks in advance

[June7]

Google: Access rich text format

Start with http://office.microsoft.com/en-us/ac...010014097.aspx

I just tested setting an unbound textbox to RTF in the TextFormat property and this allowed me to use the RTF tools on the ribbon Home tab. So I guess can be done with VBA code using the HTML code tags. However, if you want this for a report, that does complicate things.

[tikrit]

Google: Access rich text format

Start with http://office.microsoft.com/en-us/ac...010014097.aspx

I just tested setting an unbound textbox to RTF in the TextFormat property and this allowed me to use the RTF tools on the ribbon Home tab. So I guess can be done with VBA code using the HTML code tags. However, if you want this for a report, that does complicate things.

Thank you so much for your replay.
If you know how to do it I can send you the file to your email. I will pay money for you if finish the file.
Can you do it ?
Thank you so much

[June7]

I have never used RTF and don't want to build your db. I will try to help you achieve your goal but the task is yours.

As this thread points out, prior to Access2007, VBA was only way to save RTF data into record. I don't what that code would be. http://www.techrepublic.com/blog/mso...-and-2010/4795

This thread discusses old RTF coding http://stackoverflow.com/questions/5...ld-in-a-report

Access 2007 introduced RTF tool. Enter the text in control bound to memo field and use the tool to set the format.

I did some more testing. You will have to put the entire statement you want on report into the memo field. Concatenation of the RTF memo field shows only the normal text. The RTF field data did not show.

Here is a very long thread discussing the RTF issue. http://bytes.com/topic/access/answer...t-deficiencies
It suggests that the memo field can be populated programmatically. Will have to learn HTML code tags to do that. I just did a quick test to insert new record with RTF text and it works:
Currentdb.Execute "INSERT INTO Umpires(UMPID, TEST) VALUES('mine','This is a <b>test</b> of RTF.')