how to get yes/no field to display a checkbox in a combobox
in [Help]
|
From: bobh on 10 Jun 2010 10:03 Hi All, In AccessXP how to get yes/no field to display a checkbox in a combobox?? I have a combobox on a form and it displays several fields of information, one of those fields is a yes/no field. If I open the table directly that yes/no field displays as a checkbox on the screen. When I open the form and click on the combobox to open it the field displays with the words true or false instead of displaying as a checkbox. Can a yes/no field be displayed as a checkbox(as it does when the open is opened directly) in a combobox?? thanks bobh.
From: Douglas J. Steele on 10 Jun 2010 10:26 I don't believe it's possible. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele Co-author: Access 2010 Solutions, published by Wiley (no e-mails, please!) "bobh" <vulcaned(a)yahoo.com> wrote in message news:60aa1df7-3364-4aa3-9680-609749925a0e(a)a1g2000vbl.googlegroups.com... > Hi All, > > In AccessXP how to get yes/no field to display a checkbox in a > combobox?? > > I have a combobox on a form and it displays several fields of > information, one of those fields is a yes/no field. If I open the > table directly that yes/no field displays as a checkbox on the screen. > When I open the form and click on the combobox to open it the field > displays with the words true or false instead of displaying as a > checkbox. > > Can a yes/no field be displayed as a checkbox(as it does when the open > is opened directly) in a combobox?? > > thanks > bobh.
From: James A. Fortune on 10 Jun 2010 12:24 On Jun 10, 10:03 am, bobh <vulca...(a)yahoo.com> wrote: > Hi All, > > In AccessXP how to get yes/no field to display a checkbox in a > combobox?? > > I have a combobox on a form and it displays several fields of > information, one of those fields is a yes/no field. If I open the > table directly that yes/no field displays as a checkbox on the screen. > When I open the form and click on the combobox to open it the field > displays with the words true or false instead of displaying as a > checkbox. > > Can a yes/no field be displayed as a checkbox(as it does when the open > is opened directly) in a combobox?? > > thanks > bobh. As Douglas stated, what you want is not built into Access. How badly do you need to see the checkbox display? Maybe create a query, then base a form in datasheet view on that query (perhaps called frmDataSubform). Perhaps disable the scrollbars and navigation buttons. Then create a subform on the main form that has frmDataSubform as a Source Object. Change AllowEdits on the subform to 'No' if you don't want the user to be able to edit the data shown. Then use something like the click event of a field on the subform to populate a textbox or a checkbox on the main form. It's ugly, but sometimes ugly is necessary to achieve the look you want :-). Further legerdemain may be possible with creative use of the subform control's Visible property. James A. Fortune CDMAPoster(a)FortuneJames.com
From: Salad on 10 Jun 2010 12:28 bobh wrote: > Hi All, > > In AccessXP how to get yes/no field to display a checkbox in a > combobox?? > > I have a combobox on a form and it displays several fields of > information, one of those fields is a yes/no field. If I open the > table directly that yes/no field displays as a checkbox on the screen. > When I open the form and click on the combobox to open it the field > displays with the words true or false instead of displaying as a > checkbox. > > Can a yes/no field be displayed as a checkbox(as it does when the open > is opened directly) in a combobox?? > > thanks > bobh. I agree with Doug. That's combining text with graphic. Not sure why anyone would want to display a checkbox either in a combo. I prefer doing something like Done:IIF([Completed],"Yes","No") in the rowsource query and having headings on.
From: David W. Fenton on 10 Jun 2010 14:06 Salad <salad(a)oilandvinegar.com> wrote in news:u6qdnYzCYeFXj4zRnZ2dnUVZ_v2dnZ2d(a)earthlink.com: > Done:IIF([Completed],"Yes","No") in the rowsource query and > having > headings on. I go with IIf(Completed,"x",""), which is pretty close to a checkbox. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
|
Next
|
Last
Pages: 1 2 Prev: Retrieve selected value from ListBox Next: Does anyone else pronounce ODBC as OddBock? |