Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

(Access) how to automatically format exported information?

Discussion in 'Information Technology' started by BLandis, Jul 28, 2006.

  1. BLandis

    BLandis
    Expand Collapse
    Guest

    I am exporting information from Access into an Excell file. Is there a way
    that I can get the Excell file to be formated so the column names will be
    text wrapped, the column width will automatically be 10 in width or only
    allowing enough space to show the necessary information?

    Also how can I have it so that there is a drop down when I enter the first
    letter into a feild instead of having to scroll down through the entire list
    of items in Access?
     
  2. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    you have to use automation

    Pieter

    "BLandis" <BLandis@discussions.microsoft.com> wrote in message
    news:BB584682-C919-4F23-92BE-42DFE9995CFA@microsoft.com...
    >I am exporting information from Access into an Excell file. Is there a way
    > that I can get the Excell file to be formated so the column names will be
    > text wrapped, the column width will automatically be 10 in width or only
    > allowing enough space to show the necessary information?
    >
    > Also how can I have it so that there is a drop down when I enter the first
    > letter into a feild instead of having to scroll down through the entire
    > list
    > of items in Access?
     
  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    you have to use automation

    Pieter

    "BLandis" <BLandis@discussions.microsoft.com> wrote in message
    news:BB584682-C919-4F23-92BE-42DFE9995CFA@microsoft.com...
    >I am exporting information from Access into an Excell file. Is there a way
    > that I can get the Excell file to be formated so the column names will be
    > text wrapped, the column width will automatically be 10 in width or only
    > allowing enough space to show the necessary information?
    >
    > Also how can I have it so that there is a drop down when I enter the first
    > letter into a feild instead of having to scroll down through the entire
    > list
    > of items in Access?




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4367 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page