Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941

    Unanswered: Bind control to Bit data

    FE-> Access XP
    BE -> SQL Server

    I rarely do bound forms, so this one has me stumped.

    I want to bind an option group control with two check boxes to a
    field that contains the Sql Server data type = Bit. I've set the option value
    for the "No" box to 0 and the "Yes" box to -1, but only No seems to work.
    I've also tried setting "Yes" to 1, but it still didn't work.
    Inspiration Through Fermentation

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Never mind... data doesn't refresh until I leave the record. I forgot about that.
    Inspiration Through Fermentation

Posting Permissions

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