Show Only Last 5 Letters/Numbers Of A Field

D

DavidW

I am making a calendar, in the calendar is a textbox which shows one of the
fields "vin" from table "info". Their is a large amount of letters and
numbers in that field. I only need to show the last 5 numbers and letters
combined, how do you do that?
Thanks
David
 
C

Cheryl Fischer

You can use the Right() function to display these characters. Insert the
following in the Control Source property of your text box:

=Right([Vin], 5)
 
Top