Hiding Part Of a Field

[ACCESSROOKIE1950]

I have a field with 12 characters. I only want to show the last 4 characters in the field. How can I hide the first 8 characters? Thanks in advance for an help.
Everette

A little more information, what I have is a 12 digit order number which is stored as a text file. I need the last 4 characters in another field. I don't want to delete it from the order number field, but just want to show the last 4 characters in another field. Currently I have to manually do this process, it would be very nice to have it done automatically.



Thanks again Everette

[Access_Blaster]

How about a unbound text box to display your new number?
Place this in the control source.
Make sure you put your field name in between the brackets

=Right([Your field name],4)

[ACCESSROOKIE1950]

Thanks Blaster, works like a champ.
Everette