Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Using the Value of a variable in an expression

Discussion in 'Information Technology' started by Bob W, Nov 8, 2005.

  1. Bob W

    Bob W
    Expand Collapse
    Guest

    I have done this before but forgot how.
    I want to assign "Smith" to a report textbox with a programed defined
    name- FAMA.
    Dim strSuffix As String, strVariable As String
    strSuffix = "A"
    strVariable = "FAM" & strSuffix
    ?strVariable? = "Smith"
    where ? ? is desired punctuation to indicate to use the value of this
    variable, not the name.



    ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
    http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
    ----= East and West-Coast Server Farms - Total Privacy via Encryption =----
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 7 Nov 2005 20:29:24 -0800, "Bob W" <mwund at kcbx . net>
    wrote:

    >I have done this before but forgot how.
    >I want to assign "Smith" to a report textbox with a programed defined
    >name- FAMA.
    >Dim strSuffix As String, strVariable As String
    >strSuffix = "A"
    >strVariable = "FAM" & strSuffix
    >?strVariable? = "Smith"
    >where ? ? is desired punctuation to indicate to use the value of this
    >variable, not the name.


    Try Me.Controls(strVariable) = "Smith"


    John W. Vinson[MVP]
     
  4. Bob W

    Bob W
    Expand Collapse
    Guest

    Works fine thanks- I could not remember the forest for the trees- Bob
    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:vhb0n1ht2relec2bks2c31ck2a1n9grvk3@4ax.com...
    > On Mon, 7 Nov 2005 20:29:24 -0800, "Bob W" <mwund at kcbx . net>
    > wrote:
    >
    >>I have done this before but forgot how.
    >>I want to assign "Smith" to a report textbox with a programed defined
    >>name- FAMA.
    >>Dim strSuffix As String, strVariable As String
    >>strSuffix = "A"
    >>strVariable = "FAM" & strSuffix
    >>?strVariable? = "Smith"
    >>where ? ? is desired punctuation to indicate to use the value of this
    >>variable, not the name.

    >
    > Try Me.Controls(strVariable) = "Smith"
    >
    >
    > John W. Vinson[MVP]




    ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
    http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
    ----= East and West-Coast Server Farms - Total Privacy via Encryption =----
     

Share This Page