Custom Yes/No Field

  • Thread starter Thread starter Eric Dropps
  • Start date Start date
E

Eric Dropps

Hello,

A little new to access programming (I'm a MySQL/PHP guy), and I was
wondering if it's possible to change a Yes/No field to different values,
besides On/Off or True/False--ideally I would like to use Youth/Adult

Thanks!
-Eric Dropps
 
Eric said:
Hello,

A little new to access programming (I'm a MySQL/PHP guy), and I was
wondering if it's possible to change a Yes/No field to different
values, besides On/Off or True/False--ideally I would like to use
Youth/Adult

Thanks!
-Eric Dropps
Click to expand...

You can apply a "format" so that what is displayed is just about anything
you want. What is stored will always be 0 and -1 if you use a Yes/No field.
 
I rarely use Yes/No fields since they are not very flexible. I much prefer
integer or long numeric fields. Many customers think values will ALWAYS only
be yes or no. A couple weeks into a project they add lots of "maybe" values.
It is better to start out with a small lookup table that the customer can
add values to WHEN their needs change.
 
Back
Top