Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export and right align field - text fixed width (Access 2002, SP3)

    I have an Access table I need to export to a text file. The rules that were provided for the file states that certain fields must be right aligned within the number of characters set aside for that field. The specification file Access lets me create does not provide an opportunity to set alignment, only the beginning position and the field width for each field. The fields in question are numberic fields but they are left aligned when I create the text file. Is there any way to force the field to export right aligned?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Export and right align field - text fixed width (Access 2002, SP3)

    It takes a bit of work. See ACC2000: How to Export Right- or Left-Aligned Fields to a Text File (applies to Access 2002 as well).

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export and right align field - text fixed width (Access 2002, SP3)

    Thanks for the link to the site that provided me with the code to make this work.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •