Show Only Last 5 Letters/Numbers Of A Field

  • Thread starter Thread starter DavidW
  • Start date Start date
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
 
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)
 
Back
Top