Results 1 to 8 of 8

Check Box to text in report

  1. #1
    mainerain is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    17

    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 online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    45,843
    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.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  3. #3
    mainerain is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    17
    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 Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2018
    Location
    Greece
    Posts
    55
    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 Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    17
    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
    4,849
    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?
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    So, like, why do you, like, start every sentence with, like, "so"?

  7. #7
    Gicu is online now Expert
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Posts
    618
    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 Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2018
    Location
    Greece
    Posts
    55
    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, 05:47 PM
  2. Check Box -1 Value to Text
    By CementCarver in forum Reports
    Replies: 3
    Last Post: 04-22-2013, 12:37 PM
  3. Check box with an invisible text box
    By Dkriezel in forum Access
    Replies: 1
    Last Post: 12-04-2012, 08:36 PM
  4. check and return specified text
    By nosiss in forum Queries
    Replies: 7
    Last Post: 05-17-2011, 01:29 PM
  5. Replies: 6
    Last Post: 05-11-2011, 01: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
  •  
Tech Forums: Microsoft Office Forums