Changing Font parameters by use of combo boxes in outgoing emails

[MrChips]

This line works Ok in the outgoing Email,
OutMail.HTMLbody = "<p><font face=""Arial"" size=""2"" color=""black"">Hello</font></br>"


However, I am trying to use Combo boxes:- cmboFace, cmboSize, cmboColor, to give the user a choice.
I expected that something like his would work:-
OutMail.HTMLbody = "<p><font face= cmboFace size= cmboSize color= cmboColor>Hello</font></br>"
If someone could give me a clue as to the proper way to utilise the combo boxes, I would be most grateful.

I am using Access 365 in windows11

[CJ_London]

probably needs to be more like

"<p><font face=" & cmboFace & " size= " & cmboSize & " color= " & cmboColor & ">Hello</font></br>"

recommend you assign this value to a string, and debug.print it until you get it right

dim hStr as string

hStr="<p><font face=" & cmboFace & " size= " & cmboSize & " color= " & cmboColor & ">Hello</font></br>"
debug.print hStr

[MrChips]

That worked perfectly. I suppose the solution was obvious, but I certainly was unable to find it.
I can see why doing a debug.print is helpful, thank you.

Perhaps I may ask one further question?
I also want to use a textbox to provide the user with variable text in the email.
Where I have Hello in the above question, I would like to insert text32 instead.

Even trying the debug.print idea with my attempts, I have been unable to solve it myself.
Can you help me with this problem as well please?

[Welshgasman]

Again, just concatenation.

[MrChips]

I have tried that but every time I tried a versions all I got was whatever was between the < and the following >

However, I shall persevere, thank yo.

[Welshgasman]

Try

hStr="<p><font face=" & cmboFace & " size= " & cmboSize & " color= " & cmboColor & ">" & Me.Text32 & "</font></br>"
debug.print hStr

[MrChips]

Many thanks Welchgasman.
During the night, I suddenly understood what you were saying and managed to sort it out myself, based on your advice.
So, I not only have an answer to my specific problem . . . but now also for any similar future ones.,
Many thanks for your time and patience.