📄 15409.html

📁 VB技巧问答10000例 VB技巧问答10000例

💻 HTML

字号:

<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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -