Getting Error 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report detail text box that has a control source as follows

=CStr([FundDescNo]
where FundDescNo is a record source field of type Byt

Why am I am getting "Error 0" for this on the report

ctda
 
I haven't received any suggestions on this. What is Error 0 anyway? Why am I getting it from such a simple control source
ctda

----- ctdak wrote: ----

I have a report detail text box that has a control source as follows

=CStr([FundDescNo]
where FundDescNo is a record source field of type Byt

Why am I am getting "Error 0" for this on the report

ctda
 
Error 0 isn't an error. In fact, it's the value of the Error object whenever
there isn't an error.

I'm assuming that you've got an error checking routine in your code, and
that you're invoking it whether or not you need to.

What you want for error checking is something like:

Sub MySub()
On Error GoTo ErrorHandler



End_Routine:
Exit Sub

ErrorHandler:
MsgBox Err.Description & " (" & Err.Number & ")"
Resume End_Routine

End Sub

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



ctdak said:
I haven't received any suggestions on this. What is Error 0 anyway? Why
Click to expand...
am I getting it from such a simple control source.
ctdak

----- ctdak wrote: -----

I have a report detail text box that has a control source as follows:

=CStr([FundDescNo])
where FundDescNo is a record source field of type Byte

Why am I am getting "Error 0" for this on the report.

ctdak
Click to expand...
 
OK, but why am I getting this on my report instead of the value of my function in the source control
ctda

----- Douglas J. Steele wrote: ----

Error 0 isn't an error. In fact, it's the value of the Error object wheneve
there isn't an error

I'm assuming that you've got an error checking routine in your code, an
that you're invoking it whether or not you need to

What you want for error checking is something like

Sub MySub(
On Error GoTo ErrorHandle



End_Routine
Exit Su

ErrorHandler
MsgBox Err.Description & " (" & Err.Number & ")
Resume End_Routin

End Su

--
Doug Steele, Microsoft Access MV
http://I.Am/DougSteel
(No private e-mails, please



ctdak said:
I haven't received any suggestions on this. What is Error 0 anyway? Wh
Click to expand...
am I getting it from such a simple control source
ctda
----- ctdak wrote: ----
I have a report detail text box that has a control source as follows
=CStr([FundDescNo]
Click to expand...
where FundDescNo is a record source field of type Byt
Why am I am getting "Error 0" for this on the report
ctda
Click to expand...
Click to expand...
 
Back
Top