Str Function doesn't work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am moving from Access 2000 to Access 2007. I have a report in 2000 with a
control that has the following function ="***" + Right$(str$([number]),4).
It works like a charm in 2000. It produces an error in 2007 no matter what I
do. Anyone have a clue what I've done wrong?

Thanks,
 
And the error says ...?!

(if it mentions missing reference, take a look at the code modules and the
Tools | References menu ... Access may have lost track of one/more of the
reference libraries it needs).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff:

The instead of showing the last four of the number in the report is simply
shows "error" or the printed report.

Jeff Boyce said:
And the error says ...?!

(if it mentions missing reference, take a look at the code modules and the
Tools | References menu ... Access may have lost track of one/more of the
reference libraries it needs).

Regards

Jeff Boyce
Microsoft Office/Access MVP

San Diego Jack said:
I am moving from Access 2000 to Access 2007. I have a report in 2000 with
a
control that has the following function ="***" + Right$(str$([number]),4).
It works like a charm in 2000. It produces an error in 2007 no matter
what I
do. Anyone have a clue what I've done wrong?

Thanks,
Click to expand...
Click to expand...
 
?Do you have missing data?

Regards

Jeff Boyce
Microsoft Office/Access MVP

San Diego Jack said:
Jeff:

The instead of showing the last four of the number in the report is simply
shows "error" or the printed report.

Jeff Boyce said:
And the error says ...?!

(if it mentions missing reference, take a look at the code modules and
the
Tools | References menu ... Access may have lost track of one/more of the
reference libraries it needs).

Regards

Jeff Boyce
Microsoft Office/Access MVP

message
I am moving from Access 2000 to Access 2007. I have a report in 2000
with
a
control that has the following function ="***" +
Right$(str$([number]),4).
It works like a charm in 2000. It produces an error in 2007 no matter
what I
do. Anyone have a clue what I've done wrong?

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
The database field [Account Number] holds account numbers. I have created a
report to list some data about each account but want to mask the account
number. The control is a text box. The control source is
="****"+Right(Str([Account Number]),4). In 2000 it runs fine. In 2007 when
the report is run it asks for the variable Right and the variable Str. Then
where the account should show on the report it prints "#Error" So a line of
text looks like this:
#Error Jackson, J $125.26
If I change the control source to [Account Number] the account number prints.

Thanks,
 
Based on what you've described, you have a missing Reference. You may want
to re-check this.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top