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 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 (AT) yahoo (DOT) com> wrote

On Jun 10, 10:03*am, bobh <vulca... (AT) yahoo (DOT) com> wrote:
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 (AT) FortuneJames (DOT) com

bobh wrote:

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.

Salad <salad (AT) oilandvinegar (DOT) com> wrote in
news:u6qdnYzCYeFXj4zRnZ2dnUVZ_v2dnZ2d (AT) earthlink (DOT) com:

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/

David W. Fenton wrote:
Excellent. Maybe pad with spaces to center it.