A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Alignment the text in Inventory label



 
 
Thread Tools Display Modes
  #1  
Old February 26th, 2004, 03:16 PM
Lee
external usenet poster
 
Posts: n/a
Default Alignment the text in Inventory label

Hello,
This is a Inventory life tag label and I use following code for print how many labels as I want.
Option Compare Database

Option Explicit

Dim LabelBlanks&
Dim LabelCopies&
Dim BlankCount&
Dim CopyCount&

Function LabelSetup()
LabelBlanks& = Val(InputBox$("Enter Number of blank labels to skip"))
LabelCopies& = Val(InputBox$("Enter Number of Copies to Print"))
If LabelBlanks& 0 Then LabelBlanks& = 0
If LabelCopies& 1 Then LabelBlanks& = 1
End Function
Function LabelInitialize()
BlankCount& = 0
CopyCount& = 0
End Function
Function LabelLayout(R As Report)
If BlankCount& LabelBlanks& Then
R.NextRecord = False
R.PrintSection = False
BlankCount& = BlankCount& + 1
Else
If CopyCount& (LabelCopies& - 1) Then
R.NextRecord = False
CopyCount& = CopyCount& + 1
Else
CopyCount& = 0
End If
End If
End Function



----- Lee wrote: -----

Hello,

My problem is: the program allows print one label or many labels at a time. if I print one label it perfects, but if I print more than 2 at the time then the text in the second label begin to change. they are not fit in the label any more. I want to align the text so that every time I print more than 2 labels the text in the label does not change their position. Are there any suggestion would help me a lot?
Thanks,
Lee
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.