Print Preview ActiveX Active Users: 186 / Visits Today: 186
Highest Active Users: 186
Print Preview ActiveX
Home | Profile | Register | Active Topics | Members | Search | FAQ | RSS
Save Password
Forgot your Password?

 All Forums
 Print Preview
 Help file
 Tabulate - Function
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic: === Place here replies - questions Topic Next Topic: LoadTextFile - Function  


327 Posts

Posted - 07/25/2005 :  12:02:17  Show Profile
Function Tabulate


This function adds text in specified tabulated fields.


Tabulate ( colValues As Collection, colFields As Collection) As Boolean
Parameter        Description                           
  • colValues Set of string values to be displayed
  • colFields Set of field definitions
    Each Field value is a string which takes the following form:

    AlignLetter; FieldWidth; DecimalWidth; SpaceAfter

    Constant         Value      Description                            
  • AlignLetter l,r,c,d Left, right,center,decimal
  • FieldWidth twips Width of field
  • DecimalWidth twips Position of decimal point relative to right end of field. Omit if this field is not a decimal field
  • SpaceAfter twips Space after this field, before the next

    The Values collection contains a series of strings which are positioned on the same line according to the field definitions.

    If the number of values exceeds the number of fields then the function returns false and no output is generated.


    To generate a tabulated line:

    The Fields collection contains a list of strings which define a series of fields:

    Dim F New Collection;
    Dim V New Collection;

    F.Add "r 2000;500"
    F.Add "l 1500;450"
    F.Add "d 3000;600;600"
    V.Add "ID6954"
    V.Add "Customer Smith"
    V.Add "$63.87"

    Preview.Tabulate V,F

    Come and visit :

    Edited by - emiel on 11/10/2006 03:52:08
    Go to Bottom of Page
      Previous Topic: === Place here replies - questions Topic Next Topic: LoadTextFile - Function  
     New Topic  Topic Locked
     Printer Friendly
    Jump To:
    Print Preview ActiveX © Mandix Go To Top Of Page
    This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000 Version 3.4.02