Hi Sara,
In your table design ... Why did you choose "Text" as the data type ... and
not "Yes/No"?
I'd start by making that change right off the bat.
While you're in the table design view, and after you have changed the
field's data type to "Yes/No", have a look at the field's property sheet.
If you click in the "Format" row of the property sheet, it becomes a
combo-box ... giving you 3 display options (Yes/No, True/False, On/Off)
("Display options" is the operative phrase here. The data really is 0 for
False, and -1 for True ... formatting it just changes the result displayed.)
Whatever format you choose here will be the DEFAULT format for all
newly-created forms and reports. Keep in mind that the format can be changed
at will on whatever form or report you want. Just change the Format setting
in the control's property sheet.
Actually, you may even be able to do that with things set up the way you
have them right now ... but I DO encourage you to change the Data Type of
the field at the table design level.
--
--
HTH,
Don
=============================
E-Mail (if you must)
My*****@Telus.net
Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)
I'm an Access97 user, so all posted code samples are also Access97- based
unless otherwise noted.
================================================== ========================
"sara" <sa*******@yahoo.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.com...
Hi -
I've looked at many posts, and cannot find the answer on this specific
problem.
I have several fields on a table, which I've defined as "Text", 3
characters, Format Yes/No (I picked up the Text and Format Yes/No from
a Posting).
I have a form with a label and a check box for each item and the user
checks off the ones s/he wants to be "Yes".
Then, I print the value on different reports - and on the reports I
want "Yes" or "No" to print.
However, the reports are printing -1 for "yes" and "No" for "No". I
think this is because the table default value is "No", so they show
"No".
I can see that when I check a box on the form, the table value is -1,
and the display is -1.
Is there a way to have the checkbox, when checked "On" put "Yes" in
the table, and when checked "Off" (like if the user changed a "Yes" to
a "No"), put a "No" value in the table?
Thanks - Much appreciated.
Sara
On