Checkbox appears as integer on screen

[yotamoo]

Hello there,

In every form I have that can edit a database, I put a check-box titled 'Lock', which simply disable editing a certain record when checked. If I want to unlock a record I have a query that looks for all locked record and presents them. This is the code:

SELECT name, lastName, lock
FROM table
WHERE lock=yes

Problem is, the lock field shows the integer value (0/-1) and not a check-box that can be unchecked.

Any ideas why?



Thanks!

[June7]

You used a checkbox control on the form?

[yotamoo]

You used a checkbox control on the form?

Yes of course

[June7]

Well that is confusing because a checkbox control cannot show characters of any kind. If you want to provide the db for analysis, follow instructions at bottom of my post.