• Home
• Microsoft Access Tutorial
• Ms Access Right Function

Ms Access Right Function Syntax

Ms Access Right Function is the string function in microsoft access database to take the characters or words from the right side of a string. The string can be described as word(s) or text, e.g. "Please" or "Hey you!". Meanwhile, the character is the letter or number such as "A", "2", or even symbol like "$".

We're using microsoft access 2016, to use the MS Access Right Function, input this syntax:

Right ( string, number_of_characters )

For example, look at the sample below:

Right ("Please come here!", 5)

The result will be: "here!".

The number of characters is the amount of characters to be taken. If you change the number of characters into 7, the result will be changed into: "e here!". Please note that the space is considered as character too. If the number of characters is exceeded the amount of the characters (e.g. Right ("Mimo", 20)), then it will return all the character's value without errors or additional spaces.

In case if you want to use the Right Function into the value of a menu, you only have to change the String in the syntax into the menu name. Look into this picture below for the example.

 

 

In this case, we want to show only the last 4 characters of the book title in a query. So in Criteria, put the syntax. Change the string to the field name with the square brackets ([]) outside.

 

 

Aside with the query properties box, you can use the function to query SQL syntax (see the red underlined code). You can use the function into VBA Code on Macros. For VBA Code, sometimes you may see variation with variables. You can see the example here:

Dim BookSubject, BookCategory BookSubject = "Drawing 3D" BookCategory = Right (BookSubject, 2)

The BookCategory will return as "3D", not "ct" from BookSubject. This is because the BookSubject value is Drawing 3D. The 'BookSubject' and 'BookCategory' in just a variable name that can be changed. For example: A = "Drawing 3D" or B = Right (A, 2). The result will be same too: 3D.

The Right function only works for string. It will not work to other data type, such as boolean or short unless being converted.