Getting Error 0

[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

 

[Guest]

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

 

[Douglas J. Steele]

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)

I haven't received any suggestions on this. What is Error 0 anyway? Why

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

 

[Guest]

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

I haven't received any suggestions on this. What is Error 0 anyway? Wh

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