Results 1 to 3 of 3
  1. #1
    winter is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    6

    Question Change the display of Yes/No answers

    Hi, I have what is hopefully a quick question. I have several fields in my table that use a ComboBox lookup. The user can enter either 'Yes' or 'No.' I chose to have a ComboBox instead of a Yes/No format because I don't want a default value to be used. I noticed that when I am entering data in either the table or on the form, the 'Yes' and 'No' are automatically changed to -1 and 0. I'm worried that because the users will not necessarily be familiar with Access that this will confuse them. Is there a way to tell Access to keep the display as 'Yes' and 'No' on the form?



    Thanks so much!

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Have you thought about using an option group? This is what I normally use for yes/no fields. Then you just label them what you want.

  3. #3
    winter is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    6
    Thanks for the reply! The option group would work well for some of the things I'm trying to do, but not all. I'm creating a database for a questionnaire and several questions have a 'check all that apply' response, which as far as I know, can't be done with the option group. So I've basically listed each option and want the user to indicate whether or not the box has been checked. It's just now (duh!) occurring to me to just switch 'Yes' and 'No' to 'Checked' and 'Unchecked' so Access won't do its own formatting. That should work. Thanks again!

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

Similar Threads

  1. Change the value of a field
    By akhilash in forum Queries
    Replies: 0
    Last Post: 07-16-2009, 07:20 AM
  2. change() on the textbox
    By skywalker in forum Forms
    Replies: 0
    Last Post: 03-01-2009, 01:28 AM
  3. Name Change
    By skip17 in forum Access
    Replies: 0
    Last Post: 01-12-2009, 01:28 PM
  4. Change Date Into Number
    By greenbag in forum Queries
    Replies: 0
    Last Post: 11-14-2008, 04:43 PM
  5. Change of label size
    By Zoroxeus in forum Programming
    Replies: 0
    Last Post: 06-11-2007, 08:18 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