15409.html

来自「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题」· HTML 代码 · 共 23 行

HTML
23
字号
<html>
  <head>
    <title>Re: 如何将MSFlexGrid显示的资料全都印出来呢?</title>
  </head>
  <body bgcolor="#FFFFFF" vlink="#808080">
    <center>
      <h1>Re: 如何将MSFlexGrid显示的资料全都印出来呢?</h1>
    </center>
<hr size=7 width=75%>

<hr size=7 width=75%><p>
Posted by <a href="mailto:live4war@yahoo.com">战豪</a> on July 09, 1999 at 01:32:33:<p>
In Reply to: <a href="15342.html">如何将MSFlexGrid显示的资料全都印出来呢?</a> posted by 大头 on July 07, 1999 at 19:15:36:<p>
: 我用Data控制项及Adodc来存取Access的东西,<br>: 而我以MSFlexGrid来显示资料,<br>: 请问各位高手...我要如何将MSFlexGrid显示的资料全都印出来呢?<br>: 我不是要印表单哦...我是要印表单内容哦....<br>: thanks...... <p><p>假设你之资料为平均长度,可试试此CommandButton程序:<p>Private Sub cmdPrint_Click()<br>Dim aNo As Integer		'存放msFlexGrid列数变数<br>Dim bNo as Integer		'存放msFlexGrid栏数变数<br>Dim xHG As Integer		'存放Printer垂直位置变数<br>Dim i As Integer, j as Integer		'计算器<br>Dim tStr as String		'存放每列内容的变数<br>    Printer.EndDoc		'呼叫印表机停止之前工序<br>    Printer.FontSize = 12	'设定列印文字大小<br>    xHG = 567 * 1.5<br>    Printer.CurrentX = 567<br>    Printer.CurrentY = xHG<br>With myGrid<br>    .Visible = False	'避免读取Cell资料时闪烁<br>    aNo = .Rows - 1<br>    bNo = .Cols - 1<br>    For i = 0 To aNo<br>        .Row = i<br>        For j = 0 to bNo<br>	    .Col = j<br>		if j = 0 then<br>		    tStr = .Text<br>		else<br>		    tStr = tStr & vbTab & .Text<br>		end if<br>	Next j<br>        Printer.Print tStr<br>        xHG = xHG + 567<br>        Printer.CurrentX = 567<br>        Printer.CurrentY = xHG<br>    Next i<br>    .Visible = True<br>End With<br>    Printer.EndDoc<br>End Sub<p><br>Printer的CurrentX和CurrentY,就是列印时的座标,而tStr变数中之vbTab只是籍化的移位函数! ^_^<p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 15409-->
</ul><!--end: 15409-->
<br><hr size=7 width=75%><p>

</body></html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?