Re: there is an invalid use of the . (dot) or ! operator or invalid parentheses

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 16:05:54 -0700

On Fri, 27 Feb 2004 10:16:28 -0800, "jac"
<anonymous@discussions.microsoft.com> wrote:

>curOrderSubTotal is a VBA variable declared as currency.
>txtOrderSubTotal is a textbox on the form.
>I have tried curOrderSubTotal = Nz(Me.txtOrderSubTotal, 0)
>but I still get the same error. There is a lot of code on
>this command button.
>Is it possible that the control is corupt?

That, or the . ! error lies somewhere else in your code. If you
Compile the project does it compile OK? or does it highlight this line
of code? Why do you feel that this line is at fault?

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Quantcast