Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634

    Unanswered: Vanishing combobox column

    In an effort to save others the irritation I went through......

    Access 2003 sp 3 has a fun new feature that causes the bound column of a combo box based on a table or query to show up blank if the underlying field is formatted at the table level.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I would never have found that. I never ever ever format at the table level.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Actually, this bug has been well known since the week after SP3 came out. For a short article on this and other bugs introduced by this service pack, as well as a link to the hotfix that corrects the combobox bug, have a look at Allen Browne's Microsoft Access Flaws - Bugs introduced by SP3 for Access 2003
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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