Using $ in some Access Functions

  • Thread starter Thread starter Kito
  • Start date Start date
K

Kito

Some Access functions uses the $. Can someone explain
the difference.

Example: Str and Str$

Thanks,
 
With the $ extension, it can only return a string. Without the extension, it
can return a Null.

This can make a very subtle difference in terms of program speed, but you'd
have to be executing the statement a large number of times in order for it
to be noticable.

Note that using the $ extension when the input is Null will raise a run-time
error (error 94: Invalid use of Null).
 
Back
Top