Bound field to display different value 1

[Crowley16]

Hi everyone

I don't know if this is possible or not but what I want to do is to have a bound field that displays DIFFERENT values than the values stored.

e.g.

the value stored in table can be either 0 or 1 or 2 however on the form I would like the field to show none or complete or incomplete. This would be a list box.
Obviously when storing the results it would go the other way around, i.e. incomplete would be stored as 2...


Is this possible to do this without having to code the boxes?

Thanks

 

[mndrlion]

Set up your list box as follows

Row Source Type: Value List
Row Source: 0;none;1;complete;2;incomplete
Bound Column: 1

Column Count: 2
Column Widths: 0";1"

This will cause the number value to be saved in your table but the text values will be displayed in the list box.

 

[Crowley16]

wow, cool thanks for the quick response

I'm off to try it now...

You'll get a star if it works (I'm sure it will

 

[Crowley16]

Yep, works...

I doubt I'd have thought of doing that...

well, at least for a while

have a star