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

  • Thread starter Thread starter Rhonda Fischer
  • Start date Start date
R

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
 
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-
Click to expand...
Distribution.com> wrote in message
 
Back
Top