Apologies for such a 'basic' question.

I presume the way to print something is to Open a Form
with a label on it and send a string value to the label.

Is there any way to control printing attributes, e.g.
colour, size, background - apart from having a seperate
label for each word or sentence.

I'm particularly thinking of the enbedded control codes
used in the Commodore 64.

Thanks - Kirk

Based on your description, I assume by print you mean display?

use a dialog sheet with forms controls and look at the Characters
method/class.

or by the use of the term form, do you mean a worksheet made to look like a
paper form. You can just put the string in a cell and use rich text
formatting - in code, you would again use the Characters method/class.
Turn on the macro recorder and perform the action manually. Turn of the
macro recorder and look at the code.

the above assume you want different attributes for each character or subset
of characters. If you just mean for the whole label, then you set the
properties of the control. Then it depends on which "family" of controls.
ActiveX/Control Toolbox Toolbar or Forms Toolbar.

But none of them support embedded control characters as you cite although
Dick's Blog discussed a technique to use HTML. You can search google for
Daily Dose of Excel and HTML.

--
Regards,
Tom Ogilvy


"kirkm" wrote in message
...
Apologies for such a 'basic' question.

I presume the way to print something is to Open a Form
with a label on it and send a string value to the label.

Is there any way to control printing attributes, e.g.
colour, size, background - apart from having a seperate
label for each word or sentence.

I'm particularly thinking of the enbedded control codes
used in the Commodore 64.

Thanks - Kirk