Access Function List

Access Function (VBA) Access Method (VBA) Access Object Property (VBA)

This page lists all the Access functions that have been explained in this website.

Most custom Functions were created for Excel but they are usable in Access, therefore you will see my custom Functions link to Excel topics.

You may also want to read:

Differences among Function, Sub, Method, Property

String Functions

FunctionDescription
ChrConvert ASCII value to character
InstrReturn the position of substring
MidExtract substring
wCapLetterA custom Function to capitalize first letter in a sentence
wCheckAlphabetA custom Function to check if a text contains any alphabet
wCheckNumberA custom Function to check if a text contains any number
wCheckOnlyAlphabetA custom Function to check if a text contains only alphabet
wCheckOnlyNumberA custom Function to check if a text contains only number
wCheckSymbolA custom Function to check if a text contains any symbol
wCheckHKIDA custom Function to check the last digit of HKID
wCustomSortA custom Function to assign numeric value to Text for custom sort
wExtractAlphabetA custom Function to extract alphabet from text
wExtractNumberA custom Function to extract number from text
wExtractPercentA custom Function to extract Percent from text
wLpadA custom Function to add leading character
wRandomHKIDA custom Function to generate random HKID (Hong Kong ID card number)
wRandomLetterA custom Function to generate random letter a to z / A to Z / a to Z

wRandomPassword
A custom Function to generate random alphabet / number / symobol
wSumExtractNumberA custom Function to Sum number part of text in a Range
wExtractSymbolA custom Function to extract symbol from text
wRpadA custom Function to add characters to suffix
wSplitDelimit a text and extract the Nth substring
wUniqueStrA custom Function to remove duplicate in a text

Numeric Functions

[table “” not found /]

 

Date Functions

[table “” not found /]

 

Lookup/Reference Functions

[table “” not found /]

 

Boolean Functions

[table “” not found /]

 

Other Functions

[table “” not found /]