Results 1 to 2 of 2
  1. #1
    Nanuaraq is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    77

    Showing result of generated yes/no field as checkmark instead of 0 or -1

    In a query, I generate an expression that may result in either true or false.


    It is a simple IIf where I check if there is more than one transport, like this:
    IIf([NUMBER_OF_TRANSPORTS]=1;True;False)

    The result coms out as either 0 or -1.


    I would, for the sake of the human eyes looking at it, like for the result to be displayed with a checkmark instead.

    I've tried to use a calculated field in the table instead. This can be done, but this makes it harder to reprocess the data at later steps. So I would like to do the calculation via an expression in a query.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    queries are for processing data, not for user viewing. Apply your query to a form and use a checkbox for the field

    If you have to use a query an alternative is to use the format property in the query to display something else - but this is not a checkbox e.g. something like

    "";"Yes";[Red]"No"

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

Similar Threads

  1. Combo Box showing different result to Query
    By euphonium01 in forum Queries
    Replies: 2
    Last Post: 04-28-2015, 06:29 AM
  2. Replies: 4
    Last Post: 11-30-2014, 08:03 AM
  3. Help with query show checkmark
    By nightangel73 in forum Queries
    Replies: 2
    Last Post: 05-27-2014, 06:55 AM
  4. Replies: 3
    Last Post: 04-23-2014, 08:22 PM
  5. Replies: 2
    Last Post: 06-19-2013, 06:13 AM

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