$

[placek]

Hello

I've been reading this book on VBA for a while now and am
yet to understand the dollar sign symbol. An example taken
from the book is UCASE$(strTemp).

Can anyone shed some light on this mystery symbol?

Thanks

 

[Dirk Goldgar]

Hello

I've been reading this book on VBA for a while now and am
yet to understand the dollar sign symbol. An example taken
from the book is UCASE$(strTemp).

Can anyone shed some light on this mystery symbol?

Thanks

'$' is the "String" type-specifier. For functions that exist both with
and without the terminal '$', the '$' version takes String arguments
(except those that are numeric) and returns a String result, while the
version without the '$' takes Variant arguments and returns a Variant
result. The main difference is that the Variant arguments and result
may be Null without raising an error, so these are the versions you must
use when working with database fields that may have Null values.