Str Function doesn't work

[San Diego Jack]

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,

 

[Jeff Boyce]

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]

Jeff:

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

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

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,

 

[Jeff Boyce]

?Do you have missing data?

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.

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,

 

[San Diego Jack]

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,

 

[Jeff Boyce]

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