<div>
If the field that you want to display as a tick box is of type Yes/No on your database table and you insert it on the Query that is bound to your form, than, when you insert this field on your form, it should display as a &quot;tick box&quot; type.<br />
<br />
jppinto
</div>


If the field that you want to display as a tick box is of type Yes/No on your database table and you insert it on the Query that is bound to your form, than, when you insert this field on your form, it should display as a "tick box" type.

jppinto

<div>
Thanks for your post jppinto,<br />
<br />
The field in the table is called &quot;Done&quot;<br />
<br />
This field has a type of yes/no.<br />
<br />
The field &quot;Done&quot; I would like to appear in the list box as a tick and not a -1 or 0. &nbsp;So for example:<br />
<br />
lstExample<br />
Field 1 &nbsp; &nbsp;Field 2 &nbsp; &nbsp;Done<br />
Text 1 &nbsp; &nbsp; Text 2 &nbsp; &nbsp; &quot;Tick symbol&quot;<br />
Text 8 &nbsp; &nbsp; Text 4 &nbsp; &nbsp; &quot;No tick symbol&quot;<br />
etc.<br />
<br />
Hope this helps to clarify what my problem is.<br />
<br />
Thank you in advance,<br />
Terry<br />
<br />
<br />
<br />

</div>


Thanks for your post jppinto,

The field in the table is called "Done"

This field has a type of yes/no.

The field "Done" I would like to appear in the list box as a tick and not a -1 or 0.  So for example:

lstExample
Field 1    Field 2    Done
Text 1     Text 2     "Tick symbol"
Text 8     Text 4     "No tick symbol"
etc.

Hope this helps to clarify what my problem is.

Thank you in advance,
Terry





<div>
Ah...you want the tick box to appear in a Listbox?!? That's not possible, as capricorn1 said.
</div>


Ah...you want the tick box to appear in a Listbox?!? That's not possible, as capricorn1 said.

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
One of my fields in my table is a tick box. I would like to display a tick for that record in my list box (when the field is ticked). &nbsp; At the moment, when I run the SQL for that list box there is a tick, but when I run my form the list box displays &quot;-1&quot; for that field when there is a tick in the box.<br />
<br />
Is this possible and if so, can anybody assist?<br />
<br />
Thank you in advance<br />
Terry<br />

</div>
</div>


Hi experts,

One of my fields in my table is a tick box. I would like to display a tick for that record in my list box (when the field is ticked).   At the moment, when I run the SQL for that list box there is a tick, but when I run my form the list box displays "-1" for that field when there is a tick in the box.

Is this possible and if so, can anybody assist?

Thank you in advance
Terry


Displaying a &quot;tick&quot; in my list box results

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Displaying a &quot;tick&quot; in my list box results

Displaying a "tick" in my list box results