Using ‘yes/no’ with forumulas (2000)

Topic

New Reply

Back again. I’m trying to code a form so that it will look to see if the Account is Tax Exempt or not and the apply tax accordingly. Whenever I use If/than statements with yes/no controls I have no luck. This is what I wrote.

If me.TaxeExpemptStatus.value = “No” then
[SalesTax] = [LaborCost] * .06
Else: [SalesTax] = 0
End if

And, I’ve tried:

If me.TaxeExpemptStatus.value = “No” then
[SalesTax] = [LaborCost] * .06
Else if me.TaxExepmtStatus.value = “Yes” then
[SalesTax] = 0
End if

I’ve tried taking out the word “value” as well as putting in -1 for no and 1 for yes and still the code doesn’t run.

Leesha

Reply | Quote

Replies

Yes and No are constants, not strings. Take the quotes out from around them and you should be OK.

If me.TaxeExpemptStatus.value = No then

Reply | Quote

In the first place, check for spelling errors again. In your post, you have TaxExPemptStatus and TaxExePmptStatus.

In the second place, a Yes/No field has values True and False (without quotes)

Assuming that the control is named TaxExemptStatus, the code could be

If Me.TaxExemptStatus = True Then
Me.SalesTax = 0
Else
Me.SalesTax = Me.LaborCost * .06
End If

Reply | Quote

Hi,

There weren’t any spelling errors in the code. I just typed in the various things I’d tried vs cut and paste since I’d tried various versions. I’m pretty sure its related to the quotes as Charolotte just pointed out.

Thanks to both of you!
Leesha

Reply | Quote

Also Hans solution could be changed from:
If Me.TaxExemptStatus = True Then

to:
If Me.TaxExemptStatus Then

This assumes that you are indeed testing for True.

Reply | Quote

I kept the yes/no and took away the quotes and that corrected the issue. Another learning experience.

Thanks to all three of you!

Leesha

Reply | Quote

The use of yes and no doesn’t raise an error message only because you don’t have Option Explicit in your modules; you should replace them by True and False.

Reply | Quote

Morning Hans!

Missed ya yesterday, but Pat and Charlotte took care of me.

I don’t have a problem changing the yes/no to true/false but am just wondering why yes/no is even given as an option when setting up a table. Its my need to understand kicking in again!

Leesha

Reply | Quote

In a table and in a query, you can use Yes/No or True/False as you please. This is the interface for “everyone”, it should be as user-friendly as possible.
In Visual Basic, you must use True/False. Code windows are just for programmers; the end user should never see them.

Reply | Quote

OK, that makes sense to me. Thanks for the explanation!!

Alicia

Reply | Quote

That isn’t a good idea, Pat. It is recommended against in knowledgebase articles, and I have seen it cause problems.

A checkbox control needs to be evaulated either with the full expression Me.Checkbox=True or by forcing an evaulation by enclosing the reference in parens (Me.Checkbox). Not doing so is one of the many causes of databases closing but the Access process remaining open.,

Reply | Quote

Whoa, I have noted that one. Why on earth don’t they fix it, especially if they allow it?

Reply | Quote

You’d have to ask Microsoft that question. I suspect it’s more a VBA issue than a pure Access issue though, since there seems to be a memory leakage associated with that kind of code statement.

Reply | Quote