Re: Left(), Mid(), Right()

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bob Butler (tiredofit_at_nospam.com)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 12:29:12 -0800

"alpine" <alpine_don'tsendspam@mvps.org> wrote in message
news:h8p111d91upi9ak27c625vbgo1e2ftugm3@4ax.com
> The way I read your reply, you are talking about the input param.
> Just to be clear, the "$" designates that the function will *return* a
> string instead of a variant.

The $ specifies that the argument is a string *and* that the result is a
string where the non-$ version uses a Variant for both (excluding the
Replace, Date and Time functions). The non-$ versions will accept a Null as
the argument and return a Null without error while the $ versions will raise
an error if given a Null value. 

-- 
Reply to the group so all can participate
VB.Net: "Fool me once..."

Relevant Pages

  • Re: Code to delete/unlink Linked tables
    ... Public intLinkODBCTables As Variant, intLinkDB2Tables As Variant ... Public strLinkBackendDB As String, strLinkDSNname As String, strLinkLibName ... ' MsgBox "This database is in MDE format...I will delete/recreate ODBC ... Public Sub fncLinkDB2Table() ...
    (microsoft.public.access.modulesdaovba)
  • Re: OPENFILENAME A P I. User cancels ?
    ... The variable FName will be a Boolean False if no file was selected or a String containing the fully qualified file name if the user selectes a file. ... Const ahtOFN_OVERWRITEPROMPT = &H2 ... Function GetOpenFile(Optional varDirectory As Variant, ... Dim strFilter As String ...
    (microsoft.public.excel.programming)
  • RE: multi-select file dialog
    ... strCustomFilter As String ... Global Const ahtOFN_OVERWRITEPROMPT = &H2 ... Dim strFilter As String ... Function GetOpenFile(Optional varDirectory As Variant, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Replace space in text file
    ... In four of the above cases you have specified which type of variable you want VB to create (Integer, Long, String or whatever). ... in the case of vChars you have not specified the required variable type and VB will therefore create it as a Variant. ... For example, if vChars was an Integer then VB would read two bytes from the file, and if it was a Long it would read four bytes, and if it was a standard variable length String which currently contained nine characters then it would read nine characters from the file and if it was a String that currently contained just one character then it would read one character from the file. ...
    (microsoft.public.vb.general.discussion)
  • RE: multi-select file dialog
    ... strCustomFilter As String ... Global Const ahtOFN_OVERWRITEPROMPT = &H2 ... Dim strFilter As String ... Function GetOpenFile(Optional varDirectory As Variant, ...
    (microsoft.public.access.modulesdaovba)