Prev: Retrieve selected value from ListBox
Next: Does anyone else pronounce ODBC as OddBock?
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?