Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2005
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Setting Table Field Widths (2003 sp2)

    I have created a table with specific field widths (all text). When I run the macro to delete from the table and append new data, all my columns revert back to 255. How can I keep the table column sizes stay as I originally set them? Thank you!

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

    Re: Setting Table Field Widths (2003 sp2)

    That's strange - a make-table query will reset the field sizes each time you run it, but an append query shouldn't change the structure of the table.
    Could you provide more information about your macro?

  3. #3
    Lounger
    Join Date
    Jan 2005
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Setting Table Field Widths (2003 sp2)

    Good catch - I have several appends to that table, and in testing, I undid the append. Sorry to waste your time, but now it works. Thank you so much,

Posting Permissions

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