Results 1 to 3 of 3
  1. #1
    shylock is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Sep 2018
    Location
    Dayton, Ohio
    Posts
    100

    Yes/No fields ito spaces in txt boxes

    I have a continuous form that has about 300 lines. In those lines there are 10 text boxes whose control sources are Yes/No fields in a table. If the control source for a text box is "No" or "False", I want the text box show blank or just spaces. If the control sources is "Yes" or "True", I want the text box to show an "X". How can I do this?

    Samples of Form and table schema:

    Click image for larger version. 

Name:	Design.PNG 
Views:	7 
Size:	22.8 KB 
ID:	38266Click image for larger version. 

Name:	Form View.PNG 
Views:	7 
Size:	27.9 KB 
ID:	38267Click image for larger version. 

Name:	Table.jpg 
Views:	8 
Size:	101.2 KB 
ID:	38268

  2. #2
    Join Date
    Apr 2017
    Posts
    1,792
    Instead of text boxes, use check boxes. When field is False or empty, it is unchecked, when True. then it is checked (https://docs.microsoft.com/en-us/off...ccess.checkbox)

  3. #3
    shylock is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Sep 2018
    Location
    Dayton, Ohio
    Posts
    100
    Thank you ArvilLaanemets. Works like a charm! I should have thought of this, myself, but I am under deadline pressure to complete this project and have a loooong way to go.

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

Similar Threads

  1. Replies: 10
    Last Post: 04-24-2015, 01:28 PM
  2. Replies: 2
    Last Post: 08-14-2014, 04:00 PM
  3. Replies: 8
    Last Post: 01-30-2014, 01:43 PM
  4. Removing Unwanted Spaces From Table Fields, Access 2007
    By rd.prasanna in forum Programming
    Replies: 3
    Last Post: 11-11-2013, 05:23 PM
  5. Remove blank spaces after strings in fields
    By Modify_inc in forum Access
    Replies: 8
    Last Post: 08-18-2012, 06:30 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