Option Explicit Variable not defined MVP recomended me start usi

[Guest]

I have the following code:

Private Sub Text5_AfterUpdate()
If Text5 = "*pay day" Then Text5.ForeColor = 255
'Else: Text5.ForeColor = QBColor(0) 'Black

It worked fine however when I went and changed my code in my declarations
based on recomendation I got caught in this database.

Could someone please explain why also. I have only been in VBA for about 1
month and I do have some code with variables in some of the example databases
i have getting from the MVP web sites. The schooling would be much
appreciated.

Thanks,

Brian

 

[Arvin Meyer [MVP]]

It would help us if you could explain your exact error numbers and messages.
The code below doesn't have an End Sub, but that's too obvious for it to be
the real cause.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Douglas J. Steele]

I'm sorry, your question is not very clear. What do you mean by "got caught
in this database"?

The reason for using Option Explicit, which requires that all variables be
declared, is to eliminate errors caused by mistyping variable names.

 

[Guest]

By being caught I had sevral databases that I had to go back and add the
opton explicit to the code running behind the forms and some functions. I
used the data analizer in access that reccomended that I put option explicit
at the beginning of my forms. The code that I posted was the results of
using the on format selection tool when I designed the form. Access
generated this code I just used the tool.

 

[Arvin Meyer [MVP]]

Text5 should be sufficent for the code to understand without requireing a
more explicit definition. If it does require it, you should use the syntax:

Me.Text5

or

Forms!YourFormName!Text5
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com