Access: Right Function

In Access, the Right function extracts a substring from a string starting from the right-most character.

The syntax for the Right function is:

Right ( text, number_of_characters )

Text is the string that you wish to extract from.

Number_of_characters indicates the number of characters that you wish to extract starting from the right-most character.

For example:

Right ("Tech on the Net", 3) would return "Net"

Right ("Alphabet", 5) would return "habet"

VBA Code

The Right function can be used in VBA code. For example:

Dim LResult As String

LResult = Right ("Alphabet",3)

The variable LResult would now contain the value of "bet".

You can also use the Right function in a query.