Changing 0 and -1 in a field to something else

[mjj4golf]

I inherited this db and trying to make it more user friendly. I have a combobox on a form that has a "value list" of New and Return. The table/query being used has a -1 or 0(T or F). Is there a way to convert the -1 or 0 to another value; like "New" for True or "False" for Return? And also when adding a new record, and choosing "New or Return" from a combobox, how would I store it to the table as a -1 or 0?

Mike

[pbaldy]

If you want to use a combo, it could be a value list with 2 columns, the first the numeric value and the second what you want to display. The first column would be the bound column but hidden via the column widths property.

[CJ_London]

Another alternative if you are using a textbox you can use the format property for the control

;"New";"Return"

but if users can click on the control to change it, they will see 0 and -1 because they will be editing the underlying value