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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cdate Function 4
Calculating Time Difference 2
elapsed time calculation help needed 1
Adding timer to text box 1
Modifying/Appending records between subforms 2
Problem w/Date time function 2
Rewrite a Module 2
Date, Time Calculations 1

Back
Top