Building Expressions

  • the character is changed to a number when I send the info to a textbox.

    look at my design and my expression

    =[Combo0] & "- " & [Combo2] & "" & [Text27] & "- " & [Combo4] & "" & [Combo6] & "- " & [Text25]

    How do I need to build this expression?

  • maybe I am not explaining this correctly.

    HaulerID = 2

    Asset =C

    Asset Number =6565

    Material =A

    Classfication =T

    Year =2012

    Waste Hauler Account Number should be 2-C6565-AT-2012

    But the output is 2-26565-11-2012

    this is the expression I am using

    =[Combo0] & "- " & [Combo2] & "" & [Text27] & "- " & [Combo4] & "" & [Combo6] & "- " & [Text25]

  • sasansamani (11/29/2012)


    maybe I am not explaining this correctly.

    I'm afraid I don't have an answer for you but I don't believe the problem is the explanation per se. It's just that most of us aren't MSAccess experts. Might I recommend you try Experts Exchange as well as here?


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • I suggest you look at the RowSource and BoundColumn properties of each item. My guess is that you have some sot of ID field that is the BoundColumn. This is the value that will be returned when you reference it in the expression.

  • thank you very much.

    I think the problem is related to BoundColumn Property

    http://office.microsoft.com/en-us/access-help/boundcolumn-property-HA001232723.aspx

    let me see what I can do

  • Hi

    Use the cstr function to convert numeric values into text which can then be concatenated into your string. Test for null values and replace them with a valid character or string.

    Also make sure that the value you want to retrieve from the combo control is the bound value as you have discovered. If it is not, then you will also need to specify the column number (numbering starts at zero). Therefore [Combo2](1) should retrieve the value from the second column of your control.

    Cheers

    Rowan

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply