checkbox format for listbox

[cpet]

I have a listbox, based on a query, with multiple fields showing. One of the fields is a checkbox. In the query builder I used the format yes/no. When I go back in the format and display control do not stay, the entry just disappears.
In the listbox on my PC it shows as I intended. either yes or no in the field.

When I put the application on the user's PC (same version of Access - 2003 sp3, win xp on both), it shows a 0 or -1. Is there a setting in Access that would have an effect on this? I am baffled!

thanks for any and all help or suggestions

cpet

[NoellaG]

Hi,

have you checked the "display control" property of the field in teh query? I don't remember for access 2003, but for the current version; when tyou look at the field properties of the query-field you have a tab "lookup" with the "display control" property. here you can set the way it's displayed (text box, combo box, check box)

grNG

[cpet]

Yes, I am trying to get the display control to hold the info I put in. This is actually a querybuilder query based on an aggregate query. I can probably work this part out.
The big problem is that it looks one way on my development PC and then does not show the format on the user PC. There it is -1, 0. Mine is Yes No. So I wonder if there is something else I need to look at on the user's pc. There will be 10 users and I'd like some uniformity.

thanks..any other suggestions?

cpet

[cpet]

It looks right in the query but not in the listbox.
I see that I can't get a checkbox, but I really just want a yes/no format anyway. not 0,-1.

nevermind! I found a solution! instead of using the format in the querybuilder, I put
iif(restricted = 0, "", "Yes") then if it is restricted then Yes will always show, otherwise there is a blank!
cpet