Solved: Yes/No to Local/Regional in a table

[ironj32]

Is it possible to change the display of "Yes/No" to "Local/Regional"? I have a list of values that were option buttons in Excel, which is represented as TRUE/FALSE. So when it is imported to access it is shown as -1/0 .... which can be made into Yes/No in the table. But I need it to be displayed as Local/Regional. Can this be done within the table or does it have to be through a form? I hope this makes sense!
Thanks

[Oorang]

Paste this in where you would normally put the field name:
MyField:iif([MyTable].[MyField],"Local","Regional")

[ironj32]

in the table field name or form field name or query field name?

[Oorang]

In the query builder.

[ironj32]

Awesome! Thanks Oorang.