Re: Default value for a check-box



Franklin,
Please don't cross-post. Each post is generating different responses, and responders
in one group don't know what others have suggested in another group. It can only lead to
confusion, and is a duplication of effort.
I responded to you on 3/7 in the Forms group.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

"Franklin" <Franklin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FD92E6A2-69D9-4FE7-8C02-657DBB3839E3@xxxxxxxxxxxxxxxx
Should I be using something other than a check-box (yes/no) data type then? I
would ultimately like whatever value is assigned to the check box to be
'true' when it is selected. I tried putting in the values in the Tag property
and it still did not work. What am I doing wrong?

"Carl Rapson" wrote:

The default value for a checkbox is really meant to determine whether the
box is checked or unchecked by default, not as a value that is returned. Try
putting your values in the Tag property of the checkbox and use that value
if the checkbox is True.

Carl Rapson

"Franklin" <Franklin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7F253372-A7FC-4927-BF60-F41F5AEE6929@xxxxxxxxxxxxxxxx
I am trying to set up a form that will calculate a percentage average based
on certain check-boxes. Each section in the form consists of a number of
check-boxes (Yes/No data types) which I want to assign default values to.
I
have tried assigning the fields with a default value (i.e. 2.5, 5, 10,
etc)
but it doesn't seem to work when the average is calculated, or rather the
values I assigned to the check-boxes do not effect the average calculation
I
have in a separate field. How do I give a default value for a check-box,
so
that when the box is checked, that value will be applied to the control
with
that is calculating the average? Help!





.



Relevant Pages

  • Re: Default value for a check-box
    ... it sounds like you want a checkbox, ... "Carl Rapson" wrote: ... check-boxes which I want to assign default values ...
    (microsoft.public.access.forms)
  • Re: Default value for a check-box
    ... Candia Computer Consulting. ... if the checkbox is True. ... check-boxes which I want to assign default values to. ... values I assigned to the check-boxes do not effect the average calculation ...
    (microsoft.public.access.forms)
  • Re: Default value for a check-box
    ... The default value for a checkbox is really meant to determine whether the ... check-boxes which I want to assign default values to. ... values I assigned to the check-boxes do not effect the average calculation ... have in a separate field. ...
    (microsoft.public.access.forms)
  • Re: How to indicate that UDF didnt converge?
    ... Thanks for the responses. ... accuracy in this calculation, or it has diverged to some "garbage" ... or are "garbage" as well. ... I'm not sure I like the idea of a messagebox in a UDF. ...
    (microsoft.public.excel.programming)
  • RE: Help with questionnaire responses
    ... Each radio button, checkbox, and text box has a 'linked cell' property - you ... can set it to whichever cell is necessary (on any sheet). ... So, for example, sheet 2 could have the responses - column A would be called ...
    (microsoft.public.excel.worksheet.functions)