=> Display a bit value as a Text 'Yes' or 'No' on a form

[Rhonda Fischer]

Hello,

I have a form based on a query. A Text field on this
form has a 'Control Source' with a bit value in the
database, how do I take this and display the value
as a Text 'yes' for -1 and 'no' for 0.

Any suggestions would be terrific.

Thank you very much.
Rhonda

 

[Rhonda Fischer]

Hello Gene,

The field is a Text box, I'm not sure how you make a
text box read-only? However I do have a transparent
cmd box over the top with an on_click event launching
another form. So the text box can not be edited directly.
Though may have it property set to updateable anyway.

I just thought that it might require some sort of VB
code on form_load to force 0 and 1 values to display
as text 'yes' and 'no'?

Thank you kindly for your response, any ideas?

Cheerio
Rhonda

-----Original Message-----
Is this field updateable or read-only?

Gene

"Rhonda Fischer" <Rhonda.Fischer@Turners-

Distribution.com> wrote in message

 

[Gene]

Cameron Sutherland replied to your post, his idea is better then mine was
going to be.