 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007yes/no boxes from table become 0s and -1s in Labels
I have mutliple fields as check boxes in my access database. When I try to make labels of these records these fields show up as 0s and -1s on the label. I would like to know whow to create a label where the data comes across as yes and no. When you create your query - try using an immediate if statement. Something like the following where [Checkboxfield]=the name of your field in []. IIf([checkboxfield]=true,"Yes","No") This should convert a true value to "Yes" and a false value to "No". Hope that helps > I have mutliple fields as check boxes in my access database. When I try to > make labels of these records these fields show up as 0s and -1s on the label. > I would like to know whow to create a label where the data comes across as > yes and no. I typed this exactly in the querey criteria, and it would not proceed. I am not unfortunately very familiar with the SQL code. Is there somthing obviously wrong with the following? (Active is the name of this particualr field) IIf([Active]=true,"Yes","No") It shouldn't be typed in the Criteria row, it should be typed in the Field row. Cheers, Jason Lepack On May 15, 11:26 am, workATaccess <workATacc...@discussions.microsoft.com> wrote: > I typed this exactly in the querey criteria, and it would not proceed. I am > not unfortunately very familiar with the SQL code. Is there somthing > obviously wrong with the following? (Active is the name of this particualr > field) > > IIf([Active]=true,"Yes","No") That did it!! Thank you. I was able to customize them even further with that formula. That is great. > It shouldn't be typed in the Criteria row, it should be typed in the > Field row. [quoted text clipped - 10 lines] > > > > IIf([Active]=true,"Yes","No") |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.