How Do I display a Yes/No Field correctly in a List Box?
in [Form]
|
Prev: Synchronize Form and Subforms. Second Subform is the problem.
Next: remain on record that I was editing in a form after requery
From: TekWarrior on 11 Mar 2010 12:31 I have an Access 2003 project with a List Box on my form that has a Yes/No field that I set the properties to display as Yes/No, but all that displays on the List Box is "-1" for True/Yes and "0" for False/No. How can I correctly display Yes/No? -- Thanks, Tek
From: Dirk Goldgar on 11 Mar 2010 12:44 "TekWarrior" <TekWarrior(a)discussions.microsoft.com> wrote in message news:04988AE2-09A5-4240-A486-C353704FB3C4(a)microsoft.com... >I have an Access 2003 project with a List Box on my form that has a Yes/No > field that I set the properties to display as Yes/No, but all that > displays > on the List Box is "-1" for True/Yes and "0" for False/No. > > How can I correctly display Yes/No? Set the list box's rowsource to a query that formats the field using the "Yes/No" format: SELECT Format([YourBooleanField],"Yes/No") AS YN FROM YourTable; -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup)
From: TekWarrior on 11 Mar 2010 14:25
Thanks Dirk, that did it.. Heaven forbid setting it in the GUI properties would do it =D -- Thanks, Tek "Dirk Goldgar" wrote: > "TekWarrior" <TekWarrior(a)discussions.microsoft.com> wrote in message > news:04988AE2-09A5-4240-A486-C353704FB3C4(a)microsoft.com... > >I have an Access 2003 project with a List Box on my form that has a Yes/No > > field that I set the properties to display as Yes/No, but all that > > displays > > on the List Box is "-1" for True/Yes and "0" for False/No. > > > > How can I correctly display Yes/No? > > > Set the list box's rowsource to a query that formats the field using the > "Yes/No" format: > > SELECT Format([YourBooleanField],"Yes/No") AS YN > FROM YourTable; > > > -- > Dirk Goldgar, MS Access MVP > Access tips: www.datagnostics.com/tips.html > > (please reply to the newsgroup) > |