Change font for report control using VBA and MDE

#1

Using A2000. Is there a way to change the font for a report control
using VBA and and MDE?

One of the controls on the report prints a Micr line and the font may
need to be changed to a wide or narrow variation of the MICR font
depending on the users printer.

#2

Pretty sure you can simply use
Reports![NameOfReport]![NameOfControl].FontName = "name of font"

"Karl" <karl3200 (AT) gmail (DOT) com> wrote

Quote:

Using A2000. Is there a way to change the font for a report control
using VBA and and MDE?

One of the controls on the report prints a Micr line and the font may
need to be changed to a wide or narrow variation of the MICR font
depending on the users printer.

#3

Karl wrote:

Quote:

Using A2000. Is there a way to change the font for a report control
using VBA and and MDE?

One of the controls on the report prints a Micr line and the font may
need to be changed to a wide or narrow variation of the MICR font
depending on the users printer.

You can use code in the control's section's Format event
procedure.

--
Marsh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Change font for report control using VBA and MDE

comp.databases.ms-access comp.databases.ms-access

Change font for report control using VBA and MDE - 10-19-2010 , 04:26 PM

Re: Change font for report control using VBA and MDE - 10-19-2010 , 05:36 PM

Re: Change font for report control using VBA and MDE - 10-19-2010 , 11:01 PM