The following statement is included wthin a module that calls a report:

UCase$(SPOOL.BARCODE)=Ucase$("334-23-2222-234")

This returns a datatype mismatch, but only on some access
installations.  I understand that the dollar signs should be omitted
since "SPOOL.BARCODE," is a string data type, and that does fix the
problem. But why does it occur only on some machines that have been
setup using the same "seed," (OS /application  load process) .I have
hundreds of clients and some work and some don't, and I am challenged to
find out why.  Any ideas where to look?

Thanks in advance,
M Kindle

Hi Monte,

I'd double check how SPOOLBARCODE is declared.  It could be declared as a
variant which explains why changing UCase$ to UCase fixes the problem. (The
former accepts and returns a variant while the latter, a string).

HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

:The following statement is included wthin a module that calls a report:
:
:UCase$(SPOOL.BARCODE)=Ucase$("334-23-2222-234")
:
:
:This returns a datatype mismatch, but only on some access
:installations.  I understand that the dollar signs should be omitted
:since "SPOOL.BARCODE," is a string data type, and that does fix the
:problem. But why does it occur only on some machines that have been
:setup using the same "seed," (OS /application  load process) .I have
:hundreds of clients and some work and some don't, and I am challenged to
:find out why.  Any ideas where to look?
:
:Thanks in advance,
:M Kindle


: