Show Only Last 5 Letters/Numbers Of A Field

[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

 

[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)