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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

BeforeUpdate to determine length of entry and allow or not the entry 0
Windows 10 Activate windows now message 3
Showing Letters For Column Headers Rather Thann Numbers ? 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
autonumber queestion 3
Excel Worksheet_BeforeDelete code not working as expected. 1
Checking Field Length 6
Excel Sum numbers in cells that also contain text 34

Back
Top