G
Guest
Hi All.
This project is an Access 2000 project although the same error is occuring
in an XP converted versions also.
This is the line of code where the error occurs in my Access project:
.strCallFrom = Nz(Me.txtCallFrom, "")
which is within a With statement. All of the following remedial efforts &
tests have been performed on both versions. I have witheld the rest of the
code because it is large, has been working fine until now and I believe, not
relevant to the problem.
This line of code fails intermittently and happens only when the textbox is
blank but of course not every time. The textbox is not bound and is loaded
either via code or user input. When stepping through the code and hovering
the mouse over "Me.txtCallFrom", I'm not getting a tooltip displaying its
value as I would normally. I think this next pooint is the most telling
symptom but I can't figure out wht it means, I have run ?Me.txtCallFrom in
the immediate window to try and ascertain what it contains but this returns a
Type Mismatch error. I have set a watch on Me.txtCallFrom which displays
nothing (not even NULL) when it should, As you can see, I have used Nz to
handle null scenarios so its not that anyway. There are no special characters
within the textbox although this shouldn't effect it anyway. I have
compacted and repaired and I have also decompiled and recompiled the files.
I am horrified to think that this may be a corruption in the form or control
that may require that the form be rebuilt as it is the most highly developed
form in the application.
I have been developing Access based apps as my bread & butter for over 7yrs
and have never come across this error before. I'm hoping some one out there
can help me with this, maybe an MS staffer or some such
Thanks all,
Mr. Smith
This project is an Access 2000 project although the same error is occuring
in an XP converted versions also.
This is the line of code where the error occurs in my Access project:
.strCallFrom = Nz(Me.txtCallFrom, "")
which is within a With statement. All of the following remedial efforts &
tests have been performed on both versions. I have witheld the rest of the
code because it is large, has been working fine until now and I believe, not
relevant to the problem.
This line of code fails intermittently and happens only when the textbox is
blank but of course not every time. The textbox is not bound and is loaded
either via code or user input. When stepping through the code and hovering
the mouse over "Me.txtCallFrom", I'm not getting a tooltip displaying its
value as I would normally. I think this next pooint is the most telling
symptom but I can't figure out wht it means, I have run ?Me.txtCallFrom in
the immediate window to try and ascertain what it contains but this returns a
Type Mismatch error. I have set a watch on Me.txtCallFrom which displays
nothing (not even NULL) when it should, As you can see, I have used Nz to
handle null scenarios so its not that anyway. There are no special characters
within the textbox although this shouldn't effect it anyway. I have
compacted and repaired and I have also decompiled and recompiled the files.
I am horrified to think that this may be a corruption in the form or control
that may require that the form be rebuilt as it is the most highly developed
form in the application.
I have been developing Access based apps as my bread & butter for over 7yrs
and have never come across this error before. I'm hoping some one out there
can help me with this, maybe an MS staffer or some such
Thanks all,
Mr. Smith