Changing Font to Bold

[tikrit]

Hello Again,
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

 

[Big Pat]

I've never found a way of doing this!

It's not the answer you were looking for, but I have always resorted to having labels in normal text and the field itself in bold. The problem is that the "has graduated" label will have a fixed position. So you need to leave enough room for very long names, thereby leaving unsightly gaps for the majority. It's a pain!

I don't know what your expertise is like, but is there a way to programmatically alter the position of a label using VBA? If so, then maybe you could use a function incorporating the LEN of the [Name] field to position the label one or two spaces to the right.

Sorry...I don't know HOW you would do this, but it might get you thinking or give you an idea for a different question

 

[tikrit]

Thank you so much for your reply.
I do not know how to program it by VBA. I think it is difficult task.
I changed the whole plan because of this and changed the form.
I do not know why MS forgot to do something like this? It is something very important and found a lot of posts cross the internet asking the same question without soultion.
Thank you again.