combo box display other and enter another value

[kkshansid]

is it possible to make access combo box display some value and in enter other for example i want to display balanced and not balanced but enter value 0 for balanced and 1 for not balanced.i added values 0 and 1 and can enter both but can not implement show 0 for balanced and 1 for not balanced.kindly help.
thanks in advance

[TheSmileyCoder]

I see your up to almost 200 posts, so I am going to guess that you know how to make a proper combobox which is bound to 1 column but displaying another.


Change it to a textbox and type this into the Format property of the field:

"Balanced";;"Not Balanced";

The format property for a numeric textbox can display differently depending on whether its Positive;Negative;Zero;Null, and you write each format property in the above order seperated by ;.

Hope that helps.