Change Font on Form/Report

[tkelnhofer2215]

Is there a way to code a field to change its font based on a another field.

I have a

field and I want this field's font to change when I select a font from the [font] combo box on the same form (the font is saved in the same table).

I would also like my report to print with

formatted with the correct font.

Any suggestions would be appreciated

 

[Remou]

Perhaps:

Private Sub cboFont_AfterUpdate()
  Me.txtText.FontName = Me.cboFont '"Times New Roman"
  Me.txtText.FontSize = 14
End Sub

 

[TammyK]

It worked great except I am using a continuous form....the code changes all of "quote" fields when I change the "font" combo...any suggestions?