Left() function on Strings in reports

[PHampson]

Something that worked in Access 2000 does not work in
Access 2002. I have a memo field that I put the Left
(string,10) function on. I originally had it in the query
(datasource for the report). I tried it on the actual
field in the report. I have tried both the Left() and the
Left$() functions.

Access 2002 errors saying the function is not supported.
How can I accomplish this in Access 2002?

Thanks in advance.

 

[Jeff Boyce]

It sounds like your copy of Access has misplaced a reference.

Open a code module, select Tools | References.

If any of the checked references are prefixed with "MISSING", note which
one(s), uncheck, and close. Re-open, re-check and close.

Should work now.

Good luck

Jeff Boyce
<Access MVP>

 

[PHampson]

I have looked at the references and they are all OK. I
have created a new database, built one table, and created
a report on that table. In the report, I insert a text
box and choose "build" for the datasource. I choose built
in functions:text: =Left([field2],3).

When I print the report that field prints "#Error" for
all records. It seems to me that the built in functions
are part of Access. Can you try this and see if you have
the same result?

 

[Douglas J. Steele]

Works fine for me.

What data type is field2? Left only works with Text fields.

--
Doug Steele, Microsoft Access MVP

I have looked at the references and they are all OK. I
have created a new database, built one table, and created
a report on that table. In the report, I insert a text
box and choose "build" for the datasource. I choose built
in functions:text: =Left([field2],3).

When I print the report that field prints "#Error" for
all records. It seems to me that the built in functions
are part of Access. Can you try this and see if you have
the same result?

-----Original Message-----
It sounds like your copy of Access has misplaced a reference.

Open a code module, select Tools | References.

If any of the checked references are prefixed with "MISSING", note which
one(s), uncheck, and close. Re-open, re-check and close.

Should work now.

Good luck

Jeff Boyce
<Access MVP>

.

 

[Duane Hookom]

First you said "Access 2002 errors saying the function is not supported"
then you said it displayed "#Error". These are very different error
messages. The #error message is usually the result of not changing the name
of the text box.

--
Duane Hookom
MS Access MVP

I have looked at the references and they are all OK. I
have created a new database, built one table, and created
a report on that table. In the report, I insert a text
box and choose "build" for the datasource. I choose built
in functions:text: =Left([field2],3).

When I print the report that field prints "#Error" for
all records. It seems to me that the built in functions
are part of Access. Can you try this and see if you have
the same result?

-----Original Message-----
It sounds like your copy of Access has misplaced a reference.

Open a code module, select Tools | References.

If any of the checked references are prefixed with "MISSING", note which
one(s), uncheck, and close. Re-open, re-check and close.

Should work now.

Good luck

Jeff Boyce
<Access MVP>

.