I have a form(word doc) that I am uploading into Access
I have a few check boxes. If the box is checked off it will populate a 1. If
the box isn't checked off it will populate a 0

In the field I would like to convert the 1 to a yes and the 0 to a blank
field.

Where and how do I do this

Thanks

Hi Merge,

actually, I believe it will store -1 and 0...

why not store the information as Yes/No (which is actually a numeric
field) and then use something like this to show words:

IIF([fieldname]=true,"yes","")

if you do not want to use a checkbox (I personally like this the best),
you can also use a textbox control and format it to show positive
numbers as empty string, negative numbers as "Yes", zeros as empty string

Format --> "";"Yes";""

on format code -- there are 4 parts (for numbers)
1. format for positive numbers
2. format for negative numbers
3. format for 0 (zero)
4. format for null

ie:

Format --> #,##0;[red]-#,##0;0;0

for more help on Format, press the F1 key in that property on the
property sheet

Warm Regards,
Crystal
*
(: have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Merge wrote:
> I have a form(word doc) that I am uploading into Access
> I have a few check boxes. If the box is checked off it will populate a 1. If
> the box isn't checked off it will populate a 0
>
> In the field I would like to convert the 1 to a yes and the 0 to a blank
> field.
>
> Where and how do I do this
>
> Thanks

Another option you have is open the table in design mode, change the field
you want shown as a check box to a text field, save it, then change it back
to a yes/no field & save it again. I strongly recommend backing up your data
first, just in case, but I've used this to change fields at the table level
from -1 & 0 to check boxes (although, if you place a checkbox in a form and
use this field as the control source, it will display and store the data
correctly regardless).

"strive4peace" wrote:

> Hi Merge,
>
> actually, I believe it will store -1 and 0...
>
> why not store the information as Yes/No (which is actually a numeric
> field) and then use something like this to show words:
>
> IIF([fieldname]=true,"yes","")
>
> if you do not want to use a checkbox (I personally like this the best),
> you can also use a textbox control and format it to show positive
> numbers as empty string, negative numbers as "Yes", zeros as empty string
>
> Format --> "";"Yes";""
>
> on format code -- there are 4 parts (for numbers)
> 1. format for positive numbers
> 2. format for negative numbers
> 3. format for 0 (zero)
> 4. format for null
>
> ie:
>
> Format --> #,##0;[red]-#,##0;0;0
>
> for more help on Format, press the F1 key in that property on the
> property sheet
>
> Warm Regards,
> Crystal
> *
> (: have an awesome day
> *
> MVP Access
> Remote Programming and Training
> strive4peace2006 at yahoo.com
> *
>
>
>
> Merge wrote:
> > I have a form(word doc) that I am uploading into Access
> > I have a few check boxes. If the box is checked off it will populate a 1. If
> > the box isn't checked off it will populate a 0
> >
> > In the field I would like to convert the 1 to a yes and the 0 to a blank
> > field.
> >
> > Where and how do I do this
> >
> > Thanks
>

Thank you


"strive4peace" wrote:

> Hi Merge,
>
> actually, I believe it will store -1 and 0...
>
> why not store the information as Yes/No (which is actually a numeric
> field) and then use something like this to show words:
>
> IIF([fieldname]=true,"yes","")
>
> if you do not want to use a checkbox (I personally like this the best),
> you can also use a textbox control and format it to show positive
> numbers as empty string, negative numbers as "Yes", zeros as empty string
>
> Format --> "";"Yes";""
>
> on format code -- there are 4 parts (for numbers)
> 1. format for positive numbers
> 2. format for negative numbers
> 3. format for 0 (zero)
> 4. format for null
>
> ie:
>
> Format --> #,##0;[red]-#,##0;0;0
>
> for more help on Format, press the F1 key in that property on the
> property sheet
>
> Warm Regards,
> Crystal
> *
> (: have an awesome day
> *
> MVP Access
> Remote Programming and Training
> strive4peace2006 at yahoo.com
> *
>
>
>
> Merge wrote:
> > I have a form(word doc) that I am uploading into Access
> > I have a few check boxes. If the box is checked off it will populate a 1. If
> > the box isn't checked off it will populate a 0
> >
> > In the field I would like to convert the 1 to a yes and the 0 to a blank
> > field.
> >
> > Where and how do I do this
> >
> > Thanks
>

you're welcome, Merge happy to help

Warm Regards,
Crystal
*
(: have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Merge wrote:
> Thank you
>
>
> "strive4peace" wrote:
>
>> Hi Merge,
>>
>> actually, I believe it will store -1 and 0...
>>
>> why not store the information as Yes/No (which is actually a numeric
>> field) and then use something like this to show words:
>>
>> IIF([fieldname]=true,"yes","")
>>
>> if you do not want to use a checkbox (I personally like this the best),
>> you can also use a textbox control and format it to show positive
>> numbers as empty string, negative numbers as "Yes", zeros as empty string
>>
>> Format --> "";"Yes";""
>>
>> on format code -- there are 4 parts (for numbers)
>> 1. format for positive numbers
>> 2. format for negative numbers
>> 3. format for 0 (zero)
>> 4. format for null
>>
>> ie:
>>
>> Format --> #,##0;[red]-#,##0;0;0
>>
>> for more help on Format, press the F1 key in that property on the
>> property sheet
>>
>> Warm Regards,
>> Crystal
>> *
>> (: have an awesome day
>> *
>> MVP Access
>> Remote Programming and Training
>> strive4peace2006 at yahoo.com
>> *
>>
>>
>>
>> Merge wrote:
>>> I have a form(word doc) that I am uploading into Access
>>> I have a few check boxes. If the box is checked off it will populate a 1. If
>>> the box isn't checked off it will populate a 0
>>>
>>> In the field I would like to convert the 1 to a yes and the 0 to a blank
>>> field.
>>>
>>> Where and how do I do this
>>>
>>> Thanks