mid$ vs mid

[JeffL]

What is the difference between the text functions that do and don't end in $?

 

[Dirk Goldgar]

What is the difference between the text functions that do and don't end in
$?

The string-handling functions whose names end in '$' are string-only
functions -- they can't handle Null values. The non-'$' versions of them
take Variant arguments, and so can deal with argument values that are Null.

 

[JeffL]

thanks

The string-handling functions whose names end in '$' are string-only
functions -- they can't handle Null values. The non-'$' versions of them
take Variant arguments, and so can deal with argument values that are Null.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

And string-only functions (mid$, left$, right$, etc) run a wee bit faster
too.

Agreed. While the difference may be tiny, I try to use them whenever I know
I'm only dealing with strings. Sometimes I forget, but certainly in any
function where I expect performance to be critical, such as one called in a
query.