Trying to get a yes/no checkbox to work in form

[rad]

I have built a form to capture calibration data. I have an accuracy range (+
to -0 psi deviation). I have 2 fields [range1] example -1.5, and [range2]
example 1.5.
I want to have a yes/no check box that shows pass. I tried to use the
between operator, example Between [range1] and [range2] but did not work.
Any suggestions?
--RAD

 

[OssieMac]

Insert the following formula in the Control Source of the Checkbox

= [range1] >= -1.5 and [range2] <= 1.5

 

[OssieMac]

Just for interest the Between function would be used like this

=[Range1] between -1.5 and 1.5 and [range2] between -1.5 and 1.5

 

[rad]

Each gauge tested could have a different value in the [range] field.
[range] gets its value by multiplying [target]*[accuracy in the form. I have
an [actual] field that when [target] is subtracted calculates a deviation
[dev]. It is the [dev] field that I want to compare to [range1] and [range2]
for yes/no.

Any help you can provide is greatly appreciated...I'm an Access newbie.
Thanks.
--
RAD

Just for interest the Between function would be used like this

=[Range1] between -1.5 and 1.5 and [range2] between -1.5 and 1.5

--
Regards,

OssieMac

I have built a form to capture calibration data. I have an accuracy range (+
to -0 psi deviation). I have 2 fields [range1] example -1.5, and [range2]
example 1.5.
I want to have a yes/no check box that shows pass. I tried to use the
between operator, example Between [range1] and [range2] but did not work.
Any suggestions?
--RAD

 

[OssieMac]

Hi again,

Do you mean that you have 4 fields.
Range1 that can have any value
Range2 that can have any value
Dev that can have any value
Checkbox that is either True or False (Checked or Unchecked) and if Dev is
between Range1 and Range2 then CheckBox = True (Checked)?

If above is correct then insert the following in the Control Source of the
CheckBox.
=Val([Dev]) Between Val([Range1]) and Val([Range2])

I have had mixed results trying to use textboxes without the Val function.
Sometimes it works and sometimes it doesn't so I always use it now.


--
Regards,

OssieMac

Each gauge tested could have a different value in the [range] field.
[range] gets its value by multiplying [target]*[accuracy in the form. I have
an [actual] field that when [target] is subtracted calculates a deviation
[dev]. It is the [dev] field that I want to compare to [range1] and [range2]
for yes/no.

Any help you can provide is greatly appreciated...I'm an Access newbie.
Thanks.
--
RAD

Just for interest the Between function would be used like this

=[Range1] between -1.5 and 1.5 and [range2] between -1.5 and 1.5

--
Regards,

OssieMac

I have built a form to capture calibration data. I have an accuracy range (+
to -0 psi deviation). I have 2 fields [range1] example -1.5, and [range2]
example 1.5.
I want to have a yes/no check box that shows pass. I tried to use the
between operator, example Between [range1] and [range2] but did not work.
Any suggestions?
--RAD

 

[OssieMac]

I have had a further look at this and if you set the format of the text boxes
to General number then the Val function is not required.

--
Regards,

OssieMac

Each gauge tested could have a different value in the [range] field.
[range] gets its value by multiplying [target]*[accuracy in the form. I have
an [actual] field that when [target] is subtracted calculates a deviation
[dev]. It is the [dev] field that I want to compare to [range1] and [range2]
for yes/no.

Any help you can provide is greatly appreciated...I'm an Access newbie.
Thanks.
--
RAD

Just for interest the Between function would be used like this

=[Range1] between -1.5 and 1.5 and [range2] between -1.5 and 1.5

--
Regards,

OssieMac

I have built a form to capture calibration data. I have an accuracy range (+
to -0 psi deviation). I have 2 fields [range1] example -1.5, and [range2]
example 1.5.
I want to have a yes/no check box that shows pass. I tried to use the
between operator, example Between [range1] and [range2] but did not work.
Any suggestions?
--RAD

 

[rad]

OssieMac,

It works like a charm. Thank you so very much! I really appreciate you
taking the time to help me.
--
RAD

Hi again,

Do you mean that you have 4 fields.
Range1 that can have any value
Range2 that can have any value
Dev that can have any value
Checkbox that is either True or False (Checked or Unchecked) and if Dev is
between Range1 and Range2 then CheckBox = True (Checked)?

If above is correct then insert the following in the Control Source of the
CheckBox.
=Val([Dev]) Between Val([Range1]) and Val([Range2])

I have had mixed results trying to use textboxes without the Val function.
Sometimes it works and sometimes it doesn't so I always use it now.


--
Regards,

OssieMac

Each gauge tested could have a different value in the [range] field.
[range] gets its value by multiplying [target]*[accuracy in the form. I have
an [actual] field that when [target] is subtracted calculates a deviation
[dev]. It is the [dev] field that I want to compare to [range1] and [range2]
for yes/no.

Any help you can provide is greatly appreciated...I'm an Access newbie.
Thanks.
--
RAD

Just for interest the Between function would be used like this

=[Range1] between -1.5 and 1.5 and [range2] between -1.5 and 1.5

--
Regards,

OssieMac


:

I have built a form to capture calibration data. I have an accuracy range (+
to -0 psi deviation). I have 2 fields [range1] example -1.5, and [range2]
example 1.5.
I want to have a yes/no check box that shows pass. I tried to use the
between operator, example Between [range1] and [range2] but did not work.
Any suggestions?
--RAD

 

[rad]

OssieMac,

I jumped the gun. After I changed the control source and went into form
view I was looking at records I had done earlier where I had manulyy checked
the check box. It is not putting a check in for true of false. I tried it
with and without Val in the box.

--
RAD

OssieMac,

It works like a charm. Thank you so very much! I really appreciate you
taking the time to help me.
--
RAD

Hi again,

Do you mean that you have 4 fields.
Range1 that can have any value
Range2 that can have any value
Dev that can have any value
Checkbox that is either True or False (Checked or Unchecked) and if Dev is
between Range1 and Range2 then CheckBox = True (Checked)?

If above is correct then insert the following in the Control Source of the
CheckBox.
=Val([Dev]) Between Val([Range1]) and Val([Range2])

I have had mixed results trying to use textboxes without the Val function.
Sometimes it works and sometimes it doesn't so I always use it now.


--
Regards,

OssieMac

Each gauge tested could have a different value in the [range] field.
[range] gets its value by multiplying [target]*[accuracy in the form. I have
an [actual] field that when [target] is subtracted calculates a deviation
[dev]. It is the [dev] field that I want to compare to [range1] and [range2]
for yes/no.

Any help you can provide is greatly appreciated...I'm an Access newbie.
Thanks.
--
RAD


:

Just for interest the Between function would be used like this

=[Range1] between -1.5 and 1.5 and [range2] between -1.5 and 1.5

--
Regards,

OssieMac


:

I have built a form to capture calibration data. I have an accuracy range (+
to -0 psi deviation). I have 2 fields [range1] example -1.5, and [range2]
example 1.5.
I want to have a yes/no check box that shows pass. I tried to use the
between operator, example Between [range1] and [range2] but did not work.
Any suggestions?
--RAD

 

[rad]

OssieMac,

It does not seem to work. At first, I thought it did. After I changed the
control source and went into form view and looked at some pages and it was
checked. I later realized that I had manually checked
the check box previously. It is not putting a check in for true or false.
I tried it
with and without Val in the box.

--
RAD
--
RAD

I have had a further look at this and if you set the format of the text boxes
to General number then the Val function is not required.

--
Regards,

OssieMac

Each gauge tested could have a different value in the [range] field.
[range] gets its value by multiplying [target]*[accuracy in the form. I have
an [actual] field that when [target] is subtracted calculates a deviation
[dev]. It is the [dev] field that I want to compare to [range1] and [range2]
for yes/no.

Any help you can provide is greatly appreciated...I'm an Access newbie.
Thanks.
--
RAD

Just for interest the Between function would be used like this

=[Range1] between -1.5 and 1.5 and [range2] between -1.5 and 1.5

--
Regards,

OssieMac


:

I have built a form to capture calibration data. I have an accuracy range (+
to -0 psi deviation). I have 2 fields [range1] example -1.5, and [range2]
example 1.5.
I want to have a yes/no check box that shows pass. I tried to use the
between operator, example Between [range1] and [range2] but did not work.
Any suggestions?
--RAD

 

[rad]

I have it working now. It will read either true (between) or false
(outside). How do I get it to read yes or no instead of true or false?
--
RAD

OssieMac,

It does not seem to work. At first, I thought it did. After I changed the
control source and went into form view and looked at some pages and it was
checked. I later realized that I had manually checked
the check box previously. It is not putting a check in for true or false.
I tried it
with and without Val in the box.

--
RAD
--
RAD

I have had a further look at this and if you set the format of the text boxes
to General number then the Val function is not required.

--
Regards,

OssieMac

Each gauge tested could have a different value in the [range] field.
[range] gets its value by multiplying [target]*[accuracy in the form. I have
an [actual] field that when [target] is subtracted calculates a deviation
[dev]. It is the [dev] field that I want to compare to [range1] and [range2]
for yes/no.

Any help you can provide is greatly appreciated...I'm an Access newbie.
Thanks.
--
RAD


:

Just for interest the Between function would be used like this

=[Range1] between -1.5 and 1.5 and [range2] between -1.5 and 1.5

--
Regards,

OssieMac


:

I have built a form to capture calibration data. I have an accuracy range (+
to -0 psi deviation). I have 2 fields [range1] example -1.5, and [range2]
example 1.5.
I want to have a yes/no check box that shows pass. I tried to use the
between operator, example Between [range1] and [range2] but did not work.
Any suggestions?
--RAD

 

[rad]

I have it reading yes/no now. Thank you for your help.
--
RAD

I have it working now. It will read either true (between) or false
(outside). How do I get it to read yes or no instead of true or false?
--
RAD

OssieMac,

It does not seem to work. At first, I thought it did. After I changed the
control source and went into form view and looked at some pages and it was
checked. I later realized that I had manually checked
the check box previously. It is not putting a check in for true or false.
I tried it
with and without Val in the box.

--
RAD
--
RAD

I have had a further look at this and if you set the format of the text boxes
to General number then the Val function is not required.

--
Regards,

OssieMac


:


Each gauge tested could have a different value in the [range] field.
[range] gets its value by multiplying [target]*[accuracy in the form. I have
an [actual] field that when [target] is subtracted calculates a deviation
[dev]. It is the [dev] field that I want to compare to [range1] and [range2]
for yes/no.

Any help you can provide is greatly appreciated...I'm an Access newbie.
Thanks.
--
RAD


:

Just for interest the Between function would be used like this

=[Range1] between -1.5 and 1.5 and [range2] between -1.5 and 1.5

--
Regards,

OssieMac


:

I have built a form to capture calibration data. I have an accuracy range (+
to -0 psi deviation). I have 2 fields [range1] example -1.5, and [range2]
example 1.5.
I want to have a yes/no check box that shows pass. I tried to use the
between operator, example Between [range1] and [range2] but did not work.
Any suggestions?
--RAD