Set fonts?

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

Is there an automated way to allow the user to change a font in a field on a
form and then have that font print in the corresponding field on a report?
Or do I have to code it to work that way? thanks!!
 
You are the automator. You will have to code it by referring to the Font
property of the control. You can pass the value to the report by having the
report refer to a control on the form that you've placed the name of the
font in. This can be done in the report's Open event, setting the font of
the control on the report to that name. You should also be able to refer to
the font used for a control on a form and set the font on the report's
control to the same font.

Example of second method:
Me.ctlMyControl.Font = Forms!frmMyForm!ctlMyControl.Font

The form will have to be open to do this, hidden is fine if you don't want
it visible.
 
Back
Top