David,

Must have missed that post - but Edward got me on track.

I use Select ... to printer fairly often to have a quick hardcopy of SQL result sets - I use it when working on more complex Selects - especially multiple groupings and such - to make sure I'm doing what I think I'm doing. Also handy when doing RI detective work or finding problems in data ....

thanks!

>Ken,
>
>I saw a reply to your post sometime yesterday. It mentioned SET PRINTER FONT
>
>Frankly I didn't even know you could SELECT ... TO PRINT I've never had a need to do that.
>
>>Hi - I posted this a day or two ago and reveiced exactly 0 (zero - none, nada, nil, etc) responses. I can't believe somebody out there doesn't know the answer, so I'm assuming that my post got lost in the mix or that I'm blacklisted for some uknown reason.
>>
>>Anyway - HOW does one set the font that is used to print when commands such as "Disp STRU to PRINT nocon" or "SELECT * from mytable to print nocon" are issued from the command window? I cleaned my drive the other day - installed Win 98, reinstalled VFP5.0, and now - instead of the nice, small, monospace font I used to get, - it now prints in some larger - "don't fit on one line worth a darn" - font. Please HELP!