Results 1 to 2 of 2
  1. #1
    denileigh is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2006
    Posts
    3

    Output Query to Text

    I've searched the forums to no avail.



    Hoe do I set up a query so that when I output it to text I can set the column width?

    Thanks for any help you can give me.

    Dianne

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Dianne,

    Try this:

    1) Right click your query and select export; for type, use Text

    2) In the Export Text Wizard, select Fixed Width, and click the Advanced
    tab to explicitlyu set the field widths.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query Out Specific Text
    By ysabella in forum Queries
    Replies: 1
    Last Post: 11-19-2015, 03:53 AM
  2. Replies: 1
    Last Post: 10-09-2008, 04:48 AM
  3. Split text field into two text fields
    By Grant in forum Access
    Replies: 6
    Last Post: 01-31-2008, 05:52 AM
  4. Unbound text box truncating text
    By gddrew in forum Forms
    Replies: 0
    Last Post: 03-02-2006, 11:26 AM
  5. How to output only current record in query
    By mslieder in forum Access
    Replies: 0
    Last Post: 01-20-2006, 05:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums