Take first 3 characters letters from field (1 Viewer)

[stu_c]

Hi all
I have a field where the users types the area for example LONDON is there a way to auto populate this into another field showing the first 3 letters already in place?

 

[The_Doc_Man]

Look up the LEFT$(string, number) function, which will take the number of specified characters starting from the left of the string.

Left function (Visual Basic for Applications)

Office VBA reference topic

docs.microsoft.com

 

[theDBguy]

Normally, you wouldn't store this "calculated" value in the table. Instead, just use a query everytime you need this information.