Re: Using the $ after functions

Tech-Archive recommends: Fix windows errors by optimizing your registry

No that would error, you must specify a length. Of course, you could specify a length of 5000 and just get the entire string.

Left$(Null,5000) will generate an error
Left(Null,5000) will return null



John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

TheUbe wrote:
So For Example:

Dim AnyString, MyStr
AnyString = "Hello World" ' Define string.

mystring = Left$(AnyString)

I would not need to use the variant that defined how many characters from the left I wanted it would return the entire string?


.

Relevant Pages

  • RE: How do I set up a keystroke macro?
    ... SendKeys Statement ... SendKeys string[, wait] ... Each key is represented by one or more characters. ... To specify one of these characters, ...
    (microsoft.public.access.macros)
  • Re: Web DAV only works when authenticated to OWA
    ... > Dim objRequest 'As MSXML.XMLHTTPRequest ... > Dim strXMLNSInfo 'As String ... > ' Specify the URL of the new object to be created. ... > ' Put it all together in an HTTP request. ...
    (microsoft.public.exchange.development)
  • Re: Grabbing string values from the end of a string of an unknown
    ... having to specify the parameter values/never run macros unless excel has just ... Not if the string is produced by a formula. ... shown below in this recorded macro are restored. ... The settings for LookIn, LookAt, SearchOrder, and MatchByte are saved each ...
    (microsoft.public.excel.programming)
  • Web DAV only works when authenticated to OWA
    ... Dim objRequest 'As MSXML.XMLHTTPRequest ... Dim strXMLNSInfo 'As String ... ' Specify the URL of the new object to be created. ... ' Specify the Business Address Information. ...
    (microsoft.public.exchange.development)
  • Re: macbookpro/aiport problems
    ... Then you prefix $ to that hexadecimal string when you connect to the ... including WEP 128 bit hex. ... It doesn't allow me to specify ASCII or HEX. ...
    (comp.sys.mac.portables)