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

 All Forums
 Print Preview
 Help file
 ModifyColumn - Method
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic: DrawForm - Method Topic Next Topic: Drawline - Method  


327 Posts

Posted - 07/18/2005 :  16:01:36  Show Profile
Method ModifyColumn


This method modifies an existing column definition in a report.


ModifyColumn (strId As String, strTitle As String, vColWidth As Variant, vColSpaceLeft As Variant, vColSpaceRight As Variant, vDecSpace As Variant, Align As eColAlign, Fmt As Variant, FormatType As eFormatType, CalcType As eCalcType)
Parameter         Opt/Req  Description                                    
  • strId Required Identifier for column
  • strTitle Optional Title to appear at head of column
  • vColWidth Optional Printable width of column
  • vColSpaceLeft Optional Space added to left of column
  • vColSpaceRight Optional Space added to right of column
  • vDecSpace Optional Position of decimal point from right of ColWidth
  • Align Optional Alignment within column
  • Fmt Optional Format specification
  • FormatType Optional Type of format
  • CalcType Optional Calculation to be used on column
    The Align parameter can contain the following eColAlign values:
    Constant      Value  Description    
  • prCALeft 1 Left align
  • prCARight 2 Right align
  • prCACenter 3 Center align
  • prCADecimal 4 Decimal align
    The FormatType parameter can contain the following eFormatType values:
    Constant       Value   Description      
  • prFMGeneral 1 Format$
  • prFMPercent 2 FormatPercent
  • prFMNumber 3 FormatNumber
  • prFMDateTime 4 FormatDateTime
  • prFMCurrency 5 FormatCurrency
    The CalcType parameter can contain the following ecalcType values:
    Constant       Value   Description           
  • prCCNone 1 None
  • prCCCount 2 Number of rows in range
  • prCCSum 3 Sum of rows in range
  • prCCMin 4 Minimum of rows in range
  • prCCMax 5 Maximum of rows in range
  • prCCAverage 6 Average of rows in range

    This method modifies an existing column definition. Only those parameters specified are changed. It is often convenient to use named parameters in calling this method.

    See Reports in the Introduction for a description of the Reports facility in Print Preview5 Version.


    To modify the format of a column in currency format :
    Preview.ModifyColumn "Salary", FormatType:=prFMCurrency
    To modify the headername of the column and set it's width to 1000 twips :
    Preview.ModifyColumn "TotCost", Title:="Total", 1000
    See also:

    ReportHeaders --->
    ModifyReport ----->
    RecordsetReport ->
    NewReport -------->

    Come and visit :

    Edited by - emiel on 06/16/2006 11:31:48
    Go to Bottom of Page
      Previous Topic: DrawForm - Method Topic Next Topic: Drawline - Method  
     New Topic  Topic Locked
     Printer Friendly
    Jump To:
    Print Preview ActiveX © Mandix Go To Top Of Page
    This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000 Version 3.4.02