Ubound and Lbound

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cage4000 - 09 Mar 2007 23:18 GMT

How do you use Ubound and Lbound in the Expression Builder? If possible can
you list some examples?

Thanks for your help,

Cage

Reply to this Message

Allen Browne - 10 Mar 2007 01:24 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> How do you use Ubound and Lbound in the Expression Builder? If possible
> can
[quoted text clipped - 3 lines]
>
> Cage

Reply to this Message