RE: passing null strings
From: Sprinks (Sprinks_at_discussions.microsoft.com)
Date: 01/17/05
- Next message: fredg: "Re: Visitor data input form"
- Previous message: BobbyOH: "Is it possible to store Multiselct items in a table?"
- In reply to: Christopher Glaeser: "passing null strings"
- Next in thread: Christopher Glaeser: "Re: passing null strings"
- Reply: Christopher Glaeser: "Re: passing null strings"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 Jan 2005 10:39:09 -0800
Hi, Christopher.
Convert the Null string to a blank one before calling:
If IsNull(strMyString) Then
strMyString = ""
End If
Call CreateFax(strMyString)
Sprinks
"Christopher Glaeser" wrote:
> Given the subroutine definition "Sub CreateFax (Subject As String)" that
> opens frmFax
>
> and the subroutine call: "CreateFax Me.Subject"
>
> the code fails at the call if Me.Subject is Null. How do I pass a Null
> value? I want frmFax.Subject set to the value of Me.Subject, even if Null.
>
> Best,
> Christopher
>
>
>
>
- Next message: fredg: "Re: Visitor data input form"
- Previous message: BobbyOH: "Is it possible to store Multiselct items in a table?"
- In reply to: Christopher Glaeser: "passing null strings"
- Next in thread: Christopher Glaeser: "Re: passing null strings"
- Reply: Christopher Glaeser: "Re: passing null strings"
- Messages sorted by: [ date ] [ thread ]
