LBound() and UBound() apply to arrays.
Arrays are used in code.
They are not very useful in expressions in text boxes or query fields.
There's a practical example of using UBound() in code here: http://allenbrowne.com/func-10.html
The code parses a phrase into an array of words, and loops through the array
to return the n-th word.