Re: Default value for a check-box

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Sorry... I responded on 3/7 in Getting Started, not Forms.
--
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
    ... 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: Default value for a check-box
    ... Each post is generating different responses, ... 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
    ... Each selection in an option group represents a numerical value that can be used ... Candia Computer Consulting. ... check-boxes which I want to assign default values to. ... values I assigned to the check-boxes do not effect the average calculation I ...
    (microsoft.public.access.gettingstarted)
  • Re: null values in reports
    ... Candia Computer Consulting. ... The calculation in the control source is in the purchase order ... "Al Campagna" wrote: ... unbound calculated field, and then Sumin the footer will work. ...
    (microsoft.public.access.reports)