Overflow - error 6 ?????

[steve728]

I know how to overcome this problem if I'm working with numeric values but a string??? The following is an example of the line of code that produces this error.

I dimmed APNumber as String. The vno field is 6 chars wide.

If APNumber <> rsApp2.Fields("vno").VALUE Then

This problem is only occurring on my Win 98 PC and not my WinXP nor my Win 2000 Server.

I'd appreciate any ideas that can help me.

I get the same error with the following line of code. The name field is also
string type.

if IsNull(rsAPMaster.Fields("name").VALUE) then

I tried trim() just in case it would help. It doesn't.

Steve

 

[PaddyIrishMan]

My suggestion would be to try:

If APNumber <> Cstr(rsApp2.Fields("vno").VALUE) Then

Regards,
Patrick