How do I change number format?

[Steve Brown]

I have a tabel that contains numbers like
10001414598
I only want the last 7 digits to display in my report
1414598

How do I do this?
I tried puting the following expresion in the controll
source for the text box but the result displayed in the
report was 0


=Right(CStr(CLng([med_rec_nbr])),5)

 

[Victor Delgadillo]

Try this:
=Right(Str([med_rec_nbr]),7)
The above assuming the table contains Long (integers). If the strings are
alphanumeric text already, just the function right([field],7) should do.