Left() function on Strings in reports

  • Thread starter Thread starter PHampson
  • Start date Start date
P

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.
 
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>
 
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?
 
Works fine for me.

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

--
Doug Steele, Microsoft Access MVP



PHampson said:
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>

.
Click to expand...
Click to expand...
 
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


PHampson said:
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>

.
Click to expand...
Click to expand...
 
Back
Top