This list gives a brief description of the most useful functions to manipulate text in the
Access VBA language. Many of these functions have an alternate form which returns a string
rather than a variant - for example Left() and Left$(). Access Help gives more details and
will describe exactly how these functions operate in your version of Access.
Note that functions are always followed by a pair of brackets even if - like Date() - there's nothing
in them. The Access editor will sometimes remove these brackets but by entering them you are telling
Access that you are attempting to use a function.
The textbox class in Visual FoxPro 9 has a new Autocomplete
property which shows the user the previous values that have
been entered in that textbox.
Autocomplete in VFP 9
Your Access database will look more impressive if you add custom toolbars...
Custom toolbars