Results 1 to 3 of 3

Thread: check box

  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: check box

    I have field called "XTRA". this is a checkbox, when i select, its value is "-1". Now i want to change its value as, when checked, the value is "x", if not checked, the value is "null". How to change the value. Thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Cleveland USA
    Posts
    184
    You can make it look that way to the users by adding an expression in your query for reports and forms:

    Iif([Field]=-1, "X", "")

  3. #3
    Join Date
    Mar 2004
    Posts
    660
    thanks for your response. This form is base on the table, not query, this is a data enty form, how can i using query to change the value. Thanks again!

Posting Permissions

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