Printing DBF structure

Hello,

I have a strange printing problem! When "list struture"
to the printer, it always take up 2 or more lines because
of the spaces between columns. I tried everthing I could
think of. I know is not the printer, because, it used to
print fine. I tried different printer, differnt printer
fonts, still didn't make any differnt. I tried the "Shift-
Format", but that only changes the display on the screen.
Can some one please help me. Is difficult to read the way
it prints.

Thanks a bunch in advance
Nancy

John
Fri Sep 12 12:54:00 CDT 2003

I have the same problem. Simple, but this will solve the problem
open yourfilename
copy structure to structure extended
modify report structure && layout as you need
close report form editor then issue this command.

DO structure WITH "yourfilename"

procedure structure
lparameter tablename
use &tablename
copy structure to structure extended
use structure in select(1)
select structure
if messagebox('Send to Printer?',292)=6
report form structure to print prompt
else
report form structure preview
endif
close all
return

Modify as needed.
Hope this helps.
John

"Nancy Ng Hui" <nancynh@nwpros.com> wrote in message
news:1aee01c37955$1cfc3e60$a501280a@phx.gbl...
> Hello,
>
> I have a strange printing problem! When "list struture"
> to the printer, it always take up 2 or more lines because
> of the spaces between columns. I tried everthing I could
> think of. I know is not the printer, because, it used to
> print fine. I tried different printer, differnt printer
> fonts, still didn't make any differnt. I tried the "Shift-
> Format", but that only changes the display on the screen.
> Can some one please help me. Is difficult to read the way
> it prints.
>
> Thanks a bunch in advance
> Nancy

Leemi
Fri Sep 12 13:18:27 CDT 2003

Hi Nancy:

Have you tried using the SET PRINTER FONT command before issuing a LIST
STRUCTURE command? See this article for more details:

99621 Changing Font Used in Print Commands in FP for Windows
http://support.microsoft.com/?id=99621

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retires June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003


>Hello,

>I have a strange printing problem! When "list struture"
>to the printer, it always take up 2 or more lines because
>of the spaces between columns. I tried everthing I could
>think of. I know is not the printer, because, it used to
>print fine. I tried different printer, differnt printer
>fonts, still didn't make any differnt. I tried the "Shift-
>Format", but that only changes the display on the screen.
>Can some one please help me. Is difficult to read the way
>it prints.

>Thanks a bunch in advance
>Nancy

Nancy
Fri Sep 12 14:17:01 CDT 2003

Lee, Dan, and John,

Thank you so very much for your help. It works!! But I
still don't understand why I didn't have to issue SET
PRINTER command before and all of the sudden I have to
issue the command before printing??

Thanks Again Guys!!!
Nancy
>-----Original Message-----
>Hello,
>
>I have a strange printing problem! When "list struture"
>to the printer, it always take up 2 or more lines because
>of the spaces between columns. I tried everthing I could
>think of. I know is not the printer, because, it used to
>print fine. I tried different printer, differnt printer
>fonts, still didn't make any differnt. I tried
the "Shift-
>Format", but that only changes the display on the
screen.
>Can some one please help me. Is difficult to read the
way
>it prints.
>
>Thanks a bunch in advance
>Nancy
>.
>