Results 1 to 8 of 8
  1. #1
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146

    Check Box to text in report


    I would like to create a list of check boxes on a form which could be converted to specific text for a report. Thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What do you mean by a 'list' of checkboxes? And converted to what text? Suggest you provide a mockup of what you want to achieve.

    If you want to provide a db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146
    It would be convenient while I do an inspection on a piece of equipment to open a form that had multiple check boxes that could be selected when things were completed, such as “Cleaned”, “Calibrated “ etc. which when a report was run would display “Cleaned” and “Calibrated “ on the report.

  4. #4
    accesstos's Avatar
    accesstos is offline Expert
    Windows XP Access 2007
    Join Date
    Dec 2018
    Location
    Greece
    Posts
    551
    To be something "Cleaned", its ID must exist in the table "tblCleaned", along with other details of the "Cleaning" transaction. ;-)

    Then, in the report's query you can keep a field based on an expression like this:
    Code:
    IsCleaned: DCount("*";"tblCleaned";"[piece_ID]=" & [piece_ID])>0
    That means that your database seems to need a new design. :-i

  5. #5
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146
    Would you be so kind as to explain the expression seeing I am a newbie. Thanks

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Hard to know the best solution for the current design while knowing nothing about the tables structure. Might also be possible to make chkCleaned tag property to "Cleaned" and put the tag property into a report textbox. Sounds like the form isn't printed, so why not use a combo and just get the chosen value?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  7. #7
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Assuming you table (and form) has a bunch of Yes/No fields you want to check and then show the wording on the report you can use something like this as the control source for the report textboxes:

    =IIF([Calibrated]=True,"Calibrated","Not Calibrated")
    =IIF([Cleaned]=True,"Cleaned","Not Cleaned")

    This assumes the same fields are part of the report's record source.

    Cheers,
    Vlad

  8. #8
    accesstos's Avatar
    accesstos is offline Expert
    Windows XP Access 2007
    Join Date
    Dec 2018
    Location
    Greece
    Posts
    551
    Quote Originally Posted by mainerain View Post
    Would you be so kind as to explain the expression seeing I am a newbie. Thanks
    It would be better to keep the data of the completion of each job in a separate table. After that, with a query to this table, you can see if this process has been done or not and, besides, you have a history of your work (who, when, what etc).

    So, if you have a table for the cleaning procceses (say tblCleaned), the expresion of my last post returns TRUE if exist records in this table for the specific piece. That means that the specific piece have cleaned.

    Code:
    DCount("*"; Count everything
    "tblCleaned"; in table with name "tblCleaned" 
    "[piece_ID]=" & [piece_ID]) where the field "piece_ID" of table "tblCleaned" equals with the field "piece_ID" of the query where this expression take place 
    >0 and the result is greater than zero.
    I hope I'm clear now.

    The methodology of attached sample database is based on this theory.

    Best regards,
    John
    Attached Files Attached Files

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

Similar Threads

  1. Replies: 2
    Last Post: 01-10-2016, 06:47 PM
  2. Check Box -1 Value to Text
    By CementCarver in forum Reports
    Replies: 3
    Last Post: 04-22-2013, 01:37 PM
  3. Check box with an invisible text box
    By Dkriezel in forum Access
    Replies: 1
    Last Post: 12-04-2012, 09:36 PM
  4. check and return specified text
    By nosiss in forum Queries
    Replies: 7
    Last Post: 05-17-2011, 02:29 PM
  5. Replies: 6
    Last Post: 05-11-2011, 02:24 PM

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