changing data that is uploaded into a table

[Guest]

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

 

[strive4peace]

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
*

 

[Guest]

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).

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
*

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

 

[Guest]

Thank you

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
*

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

 

[strive4peace]

you're welcome, Merge happy to help

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

Thank you

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
*

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