Checkbox into a textbox

[Guest]

I have a field in a form called "other" on that field, I would want a
checkbox so that when the user adds information in the field "other" they can
check a box next to that field, so that I can keep track of that field.
Anyone know how?

 

[Al Campagna]

jac007
It would be redundant to enter a value in Other, and then set a checkbox to True to
indicate that there is an Other value.
The presence, or non-presence of a value in Other is all that's needed.
A query to find all records with Other would just have a criteria of Is Not Null.

 

[Guest]

I see your point, but then how would I add the "other" field with the fields
that have a checkbox? I have a query that is like this: Total:
Abs([field1]+[field2]+[field3]..and so on. I want to add the other field that
that query but only if there is data in that field. How can I do this?

 

[Al Campagna]

jac007
Given that each of the fields is numeric.
Abs(NZ(Field1) + Nz(Field2) + ...etc)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I see your point, but then how would I add the "other" field with the fields
that have a checkbox? I have a query that is like this: Total:
Abs([field1]+[field2]+[field3]..and so on. I want to add the other field that
that query but only if there is data in that field. How can I do this?

jac007
It would be redundant to enter a value in Other, and then set a checkbox to True to
indicate that there is an Other value.
The presence, or non-presence of a value in Other is all that's needed.
A query to find all records with Other would just have a criteria of Is Not Null.
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Guest]

That didn't work. So does somebody know how to have a checkbox with a textbox?

jac007
Given that each of the fields is numeric.
Abs(NZ(Field1) + Nz(Field2) + ...etc)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I see your point, but then how would I add the "other" field with the fields
that have a checkbox? I have a query that is like this: Total:
Abs([field1]+[field2]+[field3]..and so on. I want to add the other field that
that query but only if there is data in that field. How can I do this?

jac007
It would be redundant to enter a value in Other, and then set a checkbox to True to
indicate that there is an Other value.
The presence, or non-presence of a value in Other is all that's needed.
A query to find all records with Other would just have a criteria of Is Not Null.
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I have a field in a form called "other" on that field, I would want a
checkbox so that when the user adds information in the field "other" they can
check a box next to that field, so that I can keep track of that field.
Anyone know how?